SUMMARY

• 18 years of IT experience in analysis, design, development, implementation, support and testing of business applications and most recent endeavours include 10+ years of experience in design, development and testing of data warehouse using ETL.
• 10+ years of experience in ETL using Informatica Power enter and BIG data developer.
• Having good knowledge on SSIS packages.
• Strong experience with Data Extraction, Transformation, and Loading (ETL) from different Data sources like Hadoop HDFS, Hive, Oracle, Sybase, Informix, Azure SQL Server, DB2 and Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model using Informatica.
• Expertise in Data Modelling using Star Schema/Snowflake Schema, Fact and Dimensions tables.
• Strong experience in creating Mapping, Transformations, Workflows and Mapplets.
• Good experience in PL/SQL, SQL, Unix shell scripts and Autosys JIL Scripts.
• Strong experience in Mainframe Programing.
• Experience in using Automation Scheduling tool like Autosys and Tidal.
• Knowledge of Reporting tool - Power BI.
• Well Versed in Database testing, Data warehouse Testing, Functional Testing, Mainframe Testing and web- based applications.
• Experience in developing Software Test Plans, Test Metrics, Test Case Design, and test Scripts based on User Requirements.
• Experience in QA Methodologies and Software Testing Life Cycle (STLC).
• Peer reviews, Knowledge transfer sessions and creating training materials for the projects worked on.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

TECHNICAL SKILLS

Databases: Hadoop HDFS, Hive, Oracle, Sybase, Informix, DB2 and Microsoft SQL.

Database Tools: Toad, SQL Navigator and DB2 Control Centre

ETL Tools: Informatica Power Center, Informatica Big Data Developer and SSIS

Operating Systems: Windows and UNIX

Programming Languages: PLSQL,Cobol,JCL and JIL Scripts

Scheduling: Autosys and Tidal

Tools: HP ALM,JIRA

PROFESSIONAL EXPERIENCE

Confidential, Chicago

ETL Tools: Informatica Big Data developer 10.2.2SSIS

Database: Hadoop HDFS, Hive and Azure SQL

Responsibilities:

• Involved from End to end implementation of this project.
• Worked with Informatica Admin team to establish the Informatica environment, Database connectivity.
• Participated in business analysis, ETL requirements gathering, data modelling and documentation.
• Analysing SSIS packages.
• Designing the data transformation mappings and data quality verification programs.
• Extracted data from Hadoop HDFS and Hive and Loaded into Azure SQL.
• Investigate, debug and fix problems with Informatica Mappings and Workflows.
• Participated in Decision support team to analyse the user requirements and to translate them to technical team for new and change requests.
• Coordinated/Managed the development and project implementation and production support activities.
• Performed Unit Testing and User Acceptance testing.

Confidential, Chicago

ETL Tools: Informatica Power Centre 10.1

Database: Oracle, Sybase and Informix

Programing Language: PLSQL

Scheduling Tool: Autosys

Responsibilities:

• Involved from End to end implementation of this project.
• Worked with DIS (Data integration support team) to establish the Informatica environment, UNIX, Database connectivity and Autosys.
• Participated in business analysis, ETL requirements gathering, data modelling and documentation.
• Designing the data transformation mappings and data quality verification programs.
• Extracted data from various databases like Oracle, Informix, Sybase and Flat-files into Informatica repository.
• Developed Autosys JIL Scripts for Scheduling the Informatica workflows.
• Investigate, debug and fix problems with Informatica Mappings and Workflows.
• Participated in Decision support team to analyse the user requirements and to translate them to technical team for new and change requests.
• Coordinated/Managed the development and project implementation and production support activities.
• Created File transfer process using MFT and BHUB.
• Performed Unit Testing and User Acceptance testing.

Confidential, Chicago

Lead Developer

Responsibilities:

• Coordinated/Managed the development and project implementation and production support activities.
• Participated in business analysis, ETL requirements gathering, physical and logical data modelling and documentation.
• Designing the data transformation mappings and data quality verification programs using Informatica and PL/SQL.
• Extracted source definitions from various databases like Oracle, MS SQL Server, MS Access and Flat-files into Informatica repository.
• Developed and Tested Mappings using Informatica Power Center Designer.
• Designed Reusable Transformations and Mapplets . Used most of the Transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, Aggregator, Filter, and Sequence Generator for loading the data into Oracle database.
• Designed Workflows, reusable Tasks and Worklets using Informatica Workflow Manager SQL and Database tuning.
• Investigate, debug and fix problems with Informatica Mappings and Workflows, BO reports
• Participated in Decision support team to analyse the user requirements and to translate them to technical team for new and change requests.
• Performed unit and integration testing in User Acceptance Test (UAT), Operational Acceptance Test (OAT), Production Support Environment (PSE) and Production environments .
• Production support for data loads to DWH.