• 11 years of experience in design , development and implementation of ETL methodology for supporting data transformations processing in a corporate wide ETL Solution using Informatica Power Center 9.x/8.6, ODI 11.1, OWB 11g, OBIEE, Oracle SQL/PLSQL, Teradata , Unix and Control-M.
• Played the role of Team Lead and Senior ETL Developer.
• Having good experience in leading development team and able to deliver the deliverables as per schedule with quality.
• Strong experience in development and implementations of Data Warehousing projects.
• Expertise in creating Extract and Transformation mappings with various ETL tools
• Experience in creating the Technical design specification.
• Experience in providing estimates, doing code reviews and tracking the review logs.
• Experience in logging test cases and tracking defects in Quality Center, TFS and JIRA.
• Having knowledge in Informatica Data Quality and Data Explorer
• Having working experience with Migration projects
• Working experience in production support for ETL process.
• Expertise in writing Unix shell scripts.
• Experience in Informatica performance tuning, Query tuning, Stored Procedures, Functions, and Packages.
• Having Domain exposure in financial services, Manufacturing, prepaid card, Rating Services and Health Insurance.
• Experience with Waterfall and Agile development methodologies
• Experience in creating documents with Fusion
• Involved in support activities as L3 team.
• Proactively learns and applies new technologies and programming languages as required.
• Good communication skills, Technical skill, interpersonal skills and good interaction with team members, which drives the process towards client satisfaction.
• Excellent analytical, problem solving and troubleshooting abilities

Confidential

Senior ETL Developer

Technology worked on: Informatica Power Center 9.x, ODI 11.1 , OWB 11g and OBIEE, UNIX, SQL and PLSQL

Responsibilities:

• As Senior ETL Developer, I am responsible for
• Analyze the change requests and provide estimations
• After PAB Project Approval Board approval, work on the design and create Technical design specification document.
• Review the TDS with APW solution architect.
• Work on development for the CRs along with the team.
• Develop Informatica mappings/ work flows. Integrate the Informatica workflows with OWB Daily run process flow.
• Development and changes to OWB mappings according to the CR request.
• Used ODI ETL tool for one of the major CR Anti Money Laundering to extract the data from CPF system to Detica Application
• Create SQL procedure and packages to handle complex logic and utilities.
• Support functional testing and QA testing.
• Prepare the deployment code base and release notes.
• Provide updates in Daily scrum call
• Provide the project demos to Users.
• Create the Dashboard reports using OBIEE
• Worked on OBIEE LDAP integration for Active directory Users.
• Support migration activities.

Confidential

Senior ETL Developer and Lead.

Hardware, Software and Tools: Informatica 9.1, Teradata, TFS, Nexus, UNIX, Control-M.

Responsibilities:

• As an Senior ETL Developer and Lead, I am responsible for
• Create the technical design specification document
• Design the ETL process flow and provide appropriate instructions to follow for the development.
• Review the design with internal ARB team
• Make sure to avoid re-works by proper reviewing and planning.
• Make sure to deliver the deliverables within the scheduled time by following up with the team, source and Testing teams.
• Support the team on any development issues and guide them
• Make sure all project artifacts are maintained on the project SharePoint accordingly.
• Logging test cases in TFS and tracking defects in TFS
• Involve in the code development for complex programs
• Timely communicating for any requests or questions raised by business/ source.
• Review the code, create build requests for SIT and change requests for Production.
• Developed UNIX shell scripts

Project 3:

Confidential

Senior ETL Developer and Lead.

Responsibilities:

• As an Senior ETL Developer and Lead, I am responsible for
• Create the technical design specification document
• Design the ETL process flow and provide appropriate instructions to follow for the development.
• Make sure to avoid re-works by proper reviewing and planning.
• Came up with a re-usable framework that can be used for similar projects which
• have file based extracts.
• Encourage the team by re-shuffling the regular tasks that they perform.
• Created ETL Informatica mappings, Teradata Macros and shell scripts
• Timely communicating for any requests or questions raised by Merkle.

Project 4:

Confidential

Lead-Developer ETL

Hardware, Software and Tools: Informatica 8.6, Oracle, SQL/PLSQL, Quality Center, TOAD, UNIX

Responsibilities:

• As an ETL Lead Developer resource, I am responsible for
• Design the process flow and ETL mappings
• Clarifying issues through conf call with onsite co-ordinators and client
• Generate the XML target files based on number of issuers
• Tuning mappings for better performance
• Developed the PLSQL procedures, Mappings and Workflows

Confidential

Senior Developer for ETL

Hardware, Software and Tools: Informatica 8.6, Oracle, SQL/PLSQL, Quality Center, TOAD, UNIX

Responsibilities:

• As an ETL resource, I am responsible for
• Design the mappings based upon the requirements
• Develop the Informatica objects
• Creating the UNIX shell scripts to run the workflows
• Developed Pl/SQL procedures and functions
• Develop the reports using Business Objects
• Creating Unit test cases, executing the same
• Worked on Production support as part of production support team

Project 6:

Confidential

ETL Developer

Responsibilities:

• As a team member, was responsible for
• Developed ETL objects using Informatica
• Extracting the data from fixed width flat files
• Creating Unit test cases, executing the same
• UsednSSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

Environment:

SQL server, Informatica 7.1, Toad, UNIX