SUMMARY

• ETL Informatica expert with around 6 years of Total IT Experience in analysis, design, development, testing, deployment, and production support of Enterprise Data warehouse applications using Informatica across Healthcare, Manufacturing and Retail domains under all the phases of SDLC.
• 5+ years of vast experience in developing ETL interfaces using Informatica 10.0, 9.x, 8.x for Enterprise Data warehouse and standalone data marts.
• Expertise in developing end - to-end integration solutions using DataStage and multiple databases like ORACLE, RedShift, Teradata, MySQL, PostgreSQL and SQL Server.
• Very good in SQL and ability to write and interpret complex SQL statements and also skillful in SQL optimization and ETL debugging and performance tuning
• Experience in Extraction, Transformation and Loading (ETL) data from various data sources into Data Marts and Data Warehouse using Informatica power center components (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Informatica Administration Console).
• Strong Experience in developing Sessions/Tasks, Worklets and Workflows using Workflow Manager tools -Task Developer, Workflow & Worklet Designer.
• Extensively worked on Informatica Power center transformations as well like Expression, Joiner, Sorter, Filter, Router, Normalizer, rank, Lookups, Stored procedure, Update strategy, Source Qualifier, Union, CDC and other transformations as required.
• Worked with Teradata utilities like BTEQ, experienced in SQL.
• Experience with dimensional modeling and architecture experience implementing proper data structures for analytical reporting from an enterprise data warehouse.
• Implemented Change Data Capture (CDC) with Informatica Power Exchange.
• Experience in Data modeling; Dimensional modeling and E-R Modeling and OLTP and OLAP in Data Analysis. Very familiar with SCD1 and SCD2 in snowflake schema and star schema.
• Proficient on Data Warehouse Concepts like Dimension Tables, Fact Tables, Slowly Changing Dimensions, DataMart’s and Dimensional modeling schemas.
• Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects.
• Experience in debugging mappings, identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in writing UNIX shell scripts, SQL scripts for development, automation of ETL process, error handling and auditing purposes.
• Well versed with waterfall and Agile methodologies in Software Development Life Cycle (SDLC)
• Good knowledge of AWS (Amazon Web Services), S3 Bucket and Redshift (AWS Relational Database).

TECHNICAL SKILLS

ETL: Informatica PowerCenter 10.0, 9.5.1, 9.0, 8.1.1

ETL Scheduling Tools: Control M, ESP.

RDBMS: Oracle 11g/12c, Teradata 15, SQL Server 2008/2012, MySQL, PostgreSQL 9.2

Data Modeling: ER (OPLTP) and Dimensional (Star, Snowflake Schema);

Data Modeling Tools: Erwin 9.3/7.5

UNIX: UNIX, Shell scripting

Reporting Tools: Tableau 9, Cognos 9/10

Defect Tracking Tools: Quality Center, Bugzilla

Source Management: Bitbucket, Visual SourceSafe

Cloud Computing: Amazon Services (AWS), S3, Redshift

Programming Languages: PL/SQL

Other Tools: Notepad++, Toad, SQL Navigator, Teradata SQL Assistant, Teradata view point, JIRA, Rally

PROFESSIONAL EXPERIENCE

Confidential

ETL Informatica developer

Responsibilities:

• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this data migration project.
• Involved in documentation of Data Mapping & ETL specifications for development from source to targetbased on STM document
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into target tables.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy.
• Worked on Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping Designer and Transformations.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Leveraged JIRA to create test cases and execution.
• Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.
• Developed Parameter files for passing values to the mappings for each type of client
• Leveraged WinSCP to do flat file transfers from Source system to Redshift

Environment: Informatica Power Center 10.2, AWS Redshift, S3 bucket, Flat files, JIRA, UNIX scripting, WinSCP, Tableau

Confidential

ETL Informatica developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Translated requirements into business rules & made recommendations for innovative IT solutions.
• Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this data migration project.
• Involved in documentation of Data Mapping & ETL specifications for development from source to target.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy.
• Worked on Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplets, and Transformations.
• Maintained Development, Test and Production Mappings, migration using Repository Manager. Involved in enhancements and Maintenance activities of the data warehouse.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Tuning the mappings based on criteria, creating partitions in case of performance issues.
• Tested End to End to verify the failures in the mappings using scripts.
• Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Developed Parameter files for passing values to the mappings for each type of client
• Scheduled batch and sessions within Informatica using Informatica scheduler
• Leveraged WinSCP to do flat file transfers from Source system to Rapid Response

Environment: Informatica Power Center 10.2, AS400, DB2, Flat files, WinSCP

Confidential

ETL Informatica developer / Data Analyst

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Actively involved in interacting with business users to record user requirements and Business Analysis.
• Involved in Analysis, profiling and cleansing of source data and understanding the business process.
• Translated requirements into business rules & made recommendations for innovative IT solutions.
• Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this data migration project.
• Involved in documentation of Data Mapping & ETL specifications for development from source to target.
• Also implemented the change Data Capture (CDC) while integrating the enterprise data sources.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created the design and technical specifications for the ETL process of the project.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Worked on Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplets, and Transformations.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Wrote multiple BTEQ, MLOAD and TPUMP scripts as per business rule to load the data into Teradata tables.
• Wrote BTEQ scripts and also Teradata 14.1.0 utilizes like FASTLOAD, MLOAD, and FASTEXPORT.
• Strong on Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Tuning the mappings based on criteria, creating partitions in case of performance issues.
• Tested End to End to verify the failures in the mappings using scripts.
• Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.
• Resolving the tickets based on the priority levels raised by QA team.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Developed Parameter files for passing values to the mappings for each type of client
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.

Environment: Informatica Power Center 9.3, Oracle 10g, Cognos 10.2, DB2, Teradata 15, Flat files, SQL, putty, Toad, Quest Central, UNIX scripting

Confidential

Informatica Developer

Responsibilities:

• Worked on Informatica Power tool - Source Analyzer, Data Warehousing designer, Mapping &Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• Participated in deployment planning and in deployment of the system to production.
• Facilitated business user smoke testing of the production system by setting up test data.
• Involved in production support duties including monitoring of nightly batches.
• Responsible for updating business stakeholders and OLTP/OLAP application support teams about the status of various ETL sessions and the impact of failed sessions on data availability.
• Responsible for debugging failed ETL sessions and taking steps to mitigate impact to business users.
• Involved in code review sessions to bring the team’s attention to best practices and to identify areas of improvement.
• Responsible for implementing action items identified during code review sessions focused towards improving data quality and performance.
• Involved in performance tuning of sessions that work with large sets of data by tweaking block size, data cache size, sequence buffer length and target based commit intervals.
• Developed sessions and batches to move data at specific intervals and on demand using workflow manager.

Environment: Informatica power center 8.6, Oracle 10g, PL/SQL, Toad, Informatica B2B, Windows, SQL