Sahil

●          Over 8years of IT experience with specialization in Data Warehousing, Decision support Systems and extensive experience in implementing Full Life cycle Data Warehousing Projects.

●          Strong ETL experience using Informatica PowerCenter 10.x/9.6 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Mappings, Mapplets, Transformations.

●          Strong Experience in implementing Data warehouse solutions in Confidential Redshift; Worked on various projects to migrate data from on premise database to Confidential Refshift,RDS and S3.

●          Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server. 

●          Developed complex mappings in Informatica &Datastage to load the data from various sources into the Data Warehouse, using different transformations/ Stages like Joiner, Transformer, Aggregator, Update Strategy, Rank, Router, Lookup , Sequence Generator, Filter, Sorter, Source Qualifier.

●          Expertise in tuning existing mappings, identifying and resolving performance bottlenecks at various stages.

●          Thoroughly proficient in SQL and PL/SQL development in Oracle 12c/11g.

●          Expertise in Data Modeling, Designing of Logical and Physical DataMart.

●          4 years experience in AWS and Elastic Search.

●          Designing and deploying enterprise-wide scalable operations on Cloud Platforms

●          Implemented multiple data pipelines DAGs using python. Responsible for design and maintenanceof databases using python.

●          Creating  Data pipeline jobs using Airflow in python language and automating the jobs

●          Designing and deploying enterprise-wide scalable operations on Cloud Platforms

●          Hands on experience with EC2,ECS,S3,IAM,RDS,LAMDA,Cloud Watch and Cloud formation.

●          Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.

●          Strong SQL, PL/SQL, T-SQL programming skills in Oracle 12c/11g/10g. Proficient in writing Packages, Stored Procedures, Triggers, Views, Indexes and query optimization.

●          Extensive knowledge in Tableau and Kibana. Have created indexes and BI dashboards.

●          Exceptional analytical and problem solving skills. Good team player with the ability to communicate effectively at all levels of the development process.