SUMMARY

• 12+ years of extensive experience in data warehouse projects. Primarily working as Tech/Delivery Lead, Sr ETL developer on ETL Design, Technical Specification, Data Modeling, ETL Development, Analysis, Scoping & Assessment and Performance Tuning.
• Experience working with Informatica IICS tool effectively using it for Data Integration and Data Migration from multiple source systems.
• Experience working with IICS data integration, Monitor, Administrator, Deployments, Scheduler.
• Expert in designing ETL process with different sources like Flat file, RDBMS - Oracle, SQL Server.
• Expert in ETL Performance Tuning.
• Proficient in designing and implementing Error Table, Error Flow and Metadata Table design.
• Strong Knowledge of data warehousing concepts, Dimensional Data Modeling, Star/Snowflake Schema. Physical, Logical and conceptual data modelling.
• Data Warehousing experience in designing and building using Informatica including developing Informatica Mappings, creating Sessions, developing UNIX scripts and creating Oracle procedures/functions.
• Extensively worked on Informatica Data Quality, expert in data profiling.
• Experienced in Snowflake implementation.
• Strong analytical and data analysis skills including a thorough understanding of how to interpret customer business needs.
• Experienced in end-to-end project lifecycle and Strong delivery management skills.
• Certified AWS Technical Professional.
• Experience with Agile development - Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups.
• Experienced in coordinating with business users in requirement clarification, source data files, defining data elements, business rules, data and process flow documentation, prepare High level design documents.
• Excellent communication, interpersonal and presentation skills.

TECHNICAL SKILLS

ETL Tool: Informatica Intelligent Cloud Services(IICS) Informatica PowerCenter (10.2, 9.6/9.1//8.6,7.x) Informatica Developer(IDQ) 10.2, 9.6

Cloud: Amazon Web Services (AWS) AWS-RDS, AWS-DMSAzure

Cloud Datawarehouse: Snowflake

Analytics Tool: Power BI

Relational Databases: Oracle 11g,10g, 9iMicrosoft SQL ServerIBM DB2, MS Access

Data Modeling Tool: Erwin, SAP Power Designer

Querying Tool: SQL* PlusTOAD

Programming Languages: C, Unix shell scriptingPL/SQL

Big Data Technology: Hadoop 2.0, HDFS, Hbase, Hive. MS Azure - HD Insight, Hive, Hbase, Spark SQLSqoop.

PROFESSIONAL EXPERIENCE

Confidential, Austin TX

Tech Lead

Environment: IICS, Informatica 10.2, Oracle 12c, Sales Force, Sql Server, Unix

Responsibilities:

• Worked on PC to IICS conversion Project as a Tech/Delivery Lead.
• Analyzed, Designed and implemented conversion of Informatica PowerCenter 10.2 to IICS.
• Worked on issue resolution and promoted use of best practices
• Designed and built IICS mappings, mapping tasks to extract data from SFDC, Oracle and loaded into Sales Force.
• Designed and built IICS mappings, mapping tasks to extract data from SAP to Datawarehouse Tables and Sales Force.
• Implemented IICS Replication tasks.
• Involved in enhancements and maintenance activities of the data warehouse.
• Prepare and Review Effort estimation.
• Review Code and technical documents to meet client specifications as required.
• Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
• Standardize the existing development process for effective coding.
• Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
• Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
• Preparation of Code movement and implementation plans to UAT and Prod.
• Responsible to follow release management and defect tracking for UAT and Prod.

Confidential, Boston, MA

Data Lead

Environment: Informatica 10.2, Oracle 12c, Unix, QC, AWS S3, IICS

Responsibilities:

• Analyze functional Requirement.
• Design CML data layer.
• Prepare Technical Mapping documents.
• Prepare ETL HLD doc
• Designed and developed ETL Process for data load in AWS.
• Prepare and Review Effort estimation.
• Review Code and technical documents to meet client specifications as required.
• Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
• Standardize the existing development process for effective coding.
• Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
• Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
• Preparation of Code movement and implementation plans to UAT and Prod.
• Responsible to follow release management and defect tracking for UAT and Prod.
• Manage project risks and issues.
• Provide Project Status reporting.

Confidential, Glendale, CA

Sr ETL Developer

Environment: Informatica 9.6, Oracle 11g, DB2, Unix, Microstrategy, QC. AWS-S3

Responsibilities:

• Analyze functional Requirement and prepare Technical Mapping documents.
• Prepare ETL HLD doc.
• Prepare and Review Effort estimation.
• Work with onshore and offshore development teams to complete code deliverables
• Review Code and technical documents to meet client specifications as required.
• Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
• Standardize the existing development process for effective coding.
• Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
• Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
• Preparation of Code movement and implementation plans to UAT and Prod.
• Responsible to follow release management and defect tracking for UAT and Prod.
• Manage project risks and issues.
• Provide Project Status reporting.

Confidential, Hoboken, NJ

ETL Architect.

Environment: Informatica 9.6, Oracle 11g, MS SQL Server, Unix, Tableau, Google Cloud, JIRA

Responsibilities:

• Analyze functional Requirement and prepare Technical Mapping documents.
• Prepare ETL HLD doc.
• Prepare and Review Effort estimation.
• Create and Execute Project Plan, Resource Plan and revise as appropriate to meet changing needs and requirement.
• Work with onshore and offshore development teams to complete code deliverables
• Review Code and technical documents to meet client specifications as required.
• Worked with MDM team and BA to get Product data.
• Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
• Standardize the existing development process for effective coding.
• Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
• Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
• Preparation of Code movement and implementation plans to UAT and Prod.
• Responsible to follow release management and defect tracking for UAT and Prod.
• Manage project risks and issues.
• Provide Project Status reporting.

Confidential, New York

ETL Architect

Environment: Informatica 9.6, Oracle 11g, Unix, SQL, SharePoint.

Responsibilities:

• Analyze functional Requirement and prepare Technical Mapping documents.
• Prepare ETL solution, HLD doc.
• Create and Execute Project Plan, Resource Plan and revise as appropriate to meet changing needs and requirement.
• Prepare and Review Effort estimation.
• Work with onshore and offshore development teams to complete code deliverables
• Review Code and technical documents to meet client specifications as required.
• Standardize the existing development process for effective coding.
• Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
• Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
• Preparation of Code movement and implementation plans to UAT and Prod.
• Define and clarify project scope
• Manage project risks and issues.
• Provide Project Status reporting.

Confidential, Orlando

ETL Architect

Environment: SQL, Informatica 9.6, Teradata 14, Unix, Agile Methodology, JIRA.

Responsibilities:

• Analyze functional Requirement and prepare Technical Mapping documents.
• Prepare ETL HLD doc.
• Involved in Detail solution and ETL design
• Prepare and Review Effort estimation.
• Work with onshore and offshore development teams to complete code deliverables
• Review Code and technical documents to meet client specifications as required.
• Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
• Standardize the existing development process for effective coding.
• Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL code.
• Performance Tuning of ETL mappings at Mapping, Session, Source and Target level.
• Preparation of Code movement and implementation plans to UAT and Prod.
• Responsible to follow Project management methodology which includes promptly updating Defect Logs, System Pass Detail Document.
• Manage project risks and issues.
• Provide Project Status reporting.

Confidential, Iowa City

Tech PM / Engagement Lead

Environment: SQL, Informatica 9.1, Oracle 10 g, Unix

Responsibilities:

• Analyzing / Review requirement, Define and clarify project scope
• Involved in Detail solution design and ETL design
• Review Estimation.
• Create and Execute Project Plan, Resource Plan and revise as appropriate to meet changing needs and requirement.
• Provided the project plan and successfully delivered on-time, within scope and budget by monitoring and tracking the progress
• Manage project risks and issues.
• Work with technical onshore and offshore development teams to complete deliverables
• Preparation of Production move and implementation plan.
• Review technical documents to meet client specifications as required.
• Provide Project Status reporting.
• Involved in Improvements, Stabilization & Performance tuning of the ETL Load.
• Standardize the existing development process for effective coding.
• Manage multiple projects.

Confidential, Columbia, MD

ETL Architect / Tech Lead / Account Lead

Environment: SQL, Informatica 9.1, Oracle 9i, Netezza, Unix, SharePoint.

Responsibilities:

• ETL specification design.
• Prepare Technical Mapping documents laying out the application logic.
• Effort estimation.
• Responsible to Migrate Maps and Workflow to test and pre-production environments.
• Preparation of Production move and implementation plan.
• Responsible to conduct extensive Unit, System, Regression and Performance Testing of ETL maps
• Performance Tuning of ETL maps at Mapping, Session, Source and Target level.
• Code Review.
• Successfully manage Type1-Type 2 Slowly changing dimension with complex business requirements.
• Responsible to analyze the GSD system.
• Responsible to follow Project management methodology which includes promptly updating Defect Logs, System Pass Detail Document, Migration Checklist.
• Responsible for writing Change Control request (Database, Specification, and Mapping) and its actual implementation at all affected phase of project.