Developer (ETL - Informatica) Resume - Hire IT People

SUMMARY

Nearly 6 years of IT experience and past 2.9 years’ experience primarily on Data warehouse projects using ETL informatica power center, SQL Server on UNIX and windows platforms. Around 4 years of experience in mainframes using Cobol, JCL and DB2.
Experience in developing ETL pipelines from variety of data sources.
Developing test strategies, test plans, scenarios and scripts for all testing activities - including unit, integration, ETL.
Insightful knowledge of Data warehousing concepts and Dimensional modeling like Star and Snowflake Schema.
Participated in all phases of Software Development Life cycle using Agile and Waterfall Methodology like preparation of Design & Approach Documents, Requirement Gathering, Gap Analysis and Defect Resolution.
Handled Multiple Stakeholders by liaising between Client SMEs, Offshore team and Business Representatives, clarifying key business and design queries
Received Star of the Quarter, On the spot award and Best Team awards.

TECHNICAL SKILLS

Tools: ETL Informatica PowerCenter 9.6, 10.1, JIRA, Cob editor, XPEDITOR, HP Quality center

Database: Oracle 11g, SQL server, Teradata, DB2

Language(s): COBOL, SQL, ECL, JCL, Basics of Java

Operating Systems &: WinSCP Putty, SPUFI, TSO/ISPF, Unix, Z/OS, Windows Utilities 98/2000/NT/XP/7/8

Scheduler: Oracle UC4, CA CA7

Others: Microsoft Word, Microsoft Excel, Microsoft Project, Mainframe, Fileaid, Eclipse and TSO

PROFESSIONAL EXPERIENCE

Confidential

Developer (ETL - Informatica)

Responsibilities:

Participated in Requirement Gathering, Efforts estimate, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL mapping documents.
Developed Complex Mappings in Informatica using Power Centre transformations (Source Qualifier, Joiner, Lookups, Filter, Router, Aggregator, Expression, Stored Procedure and Sequence generator transformations), Mapping Parameters/Variables, Parameter files, SQL overrides, Transformation Language.
Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and SQL Server to the Data mart on Oracle database.
Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
Developed mappings in Informatica for Loading from sources using different transformations.
Insightful knowledge of Data warehousing concepts and Dimensional modeling like Star and Snowflake Schema.

Environment: Informatica Power Center 9.6/10.1, JIRA, Oracle 11g, SQL, Windows, UNIX

Mainframe (Technical Lead/ Developer)

Confidential

Responsibilities:

Analyzed high level business and system requirement to come up with detailed platform design and estimates Delivery timelines.
Experience of working closely with project manager to come up with development resource requirement and delivery timelines in accordance with overall project timeline.
Worked on no of Live issues with client at client site and offshore, and Ad hoc queries resolution.
Assigning and follow up the defects to the development team raised by QA during ST, SIT and UAT.
Participated in project implementation at client side as well as at offshore. Took active part in code reviews and other performance enhancing activities of the project and also played a key role in pre and post deployment activities.
Write COBOL and DB2 programs, new/update JCL, unit test plan, Execution of unit test cases, Preparation of End of Test report for unit testing,
Write SQL DDLs to create, modify and drop tables in development environment alias with DBA.
Presenting code walkthrough to client, EOTR walkthrough to QA, Maintaining mainframe quality standard.

Environment: COBOL, JCL, Mainframe Fileaid, Mainframe TSO, DB2, VSAM, UNIXWindows NT/XP, JIRA