SUMMARY

• Overall around 11 years of IT experience as Senior Informatica (ETL) Developer.
• Good work experience with Informatica ETL tool (Mapping Design, Development, Support and Unit Testing & Debugging.)
• Proficiency in understanding of business processes involved in development of Projects and expertise in analyzing, designing and developing of mappings.
• Optimize Informatica Mappings and Sessions to improve the performance.
• Experience in integration of various data sources like Oracle, Sql Server, Flat files (.txt,.csv).
• Good knowledge in Data Warehouse Architecture and Data Warehouse concepts.
• Demonstrate ability in grasping new concepts (Both Technical & Business) with strong analytical and problem - solving skills.
• Highly motivated team player with organizational and analytical skills and with a passion to work in challenging environment and adaptable to varying circumstances.
• Good communication and good rapport with customers and commitment towards application success and support.
• Provides product and/or process subject matter expertise necessary to support design, development, testing and execution of technology solutions.
• Expertise in Data Warehouse/Data mart, File feeds, ODS, OLTP and OLAP implementations teamed with project scope, data modeling, ETL development, System testing, Implementation and production support.
• Having conceptual Knowledge on reporting tools SAP BO, Tableau.
• Analyze business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems
• Perform Requirement Analysis and Effort Estimations and resource required for the estimations.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 8.x/9.x/10.x

Databases: Oracle 11g, 9i, SQL Server 2008, Teradata 14

OS/Environment: UNIX, Windows 2003 Server Edition, Windows XP.

Languages: C, SQL, PL/SQL .

Ticketing Tool: Remedy, GE internal Tool.

Reporting Tools: SAP BO, Tableau.

Scripting: UNIX Shell Scripting.

Scheduling Tools: AutoSys, Control-M, Tidal Enterprise Solution.

PROFESSIONAL EXPERIENCE

Sr. ETL Developer

Confidential

Responsibilities:

• Working with Source application owners, Business Analysts, Users in gathering requirements.
• Analyzing requirements and creating Technical Design Document, Coding methodologies and strategies to implemented for development.
• Extensively used different transformations like Source Qualifier, Expression, Lookup, Filter, Update Strategy, Router, and Sequence Generator Using ETL Process to Extract, Transform and load the data into Staging Tables, Flat Files data Warehouse.
• Developing shell scripts for inbound, outbound file management.
• Developing Autosys JIL Code to schedule and automate informatica workflows.
• Involving in Performance tuning/bottlenecks and eliminated the bottlenecks to optimize the performance.
• Developing the Mapping Variables and Mapping Parameters for code re usability.
• Involving in Preparing Unit test cases, System Test Cases and User- acceptance test case.
• Migrating ETL Code from one environment to another environment.
• Involving in sever migration activities includes checking and changing session relational connections, Sftp connections for source and target file transfer using Shell scripting and performing the test load in Development and QA environment.
• Involved in Performance tuning/bottlenecks and eliminated the bottlenecks to optimize the performance.
• Scheduling meetings with business users and Offshore team to ensure the status of the activities and tasks.
• Monitor all production issues and inquiries and provide efficient resolution for same.

Environment: Informatica 10.x, Oracle, shell scripting, Flat files, SQL Developer, AutoSys.

Sr. ETL Developer/Onsite Lead

Confidential

Responsibilities:

• Interacted with Business Analyst to understand the business requirement.
• Collaborate with all developers and business users to gather required data and execute all ETL programs and scripts on systems and implement all data warehouse activities and prepare reports for same.
• Extensively used different transformations like Source Qualifier, Expression, Lookup, Filter, Update Strategy, Router, Normalizer, and Sequence Generator Using ETL Process to Extract, Transform and load the data into Staging Tables, Flat Files and data Warehouse.
• Involved in Preparing Unit test cases, System Test Cases and User- acceptance test
• Involved in sever migration activities includes checking and changing session relational connections, Sftp connections for source and target file transfer and performing the test load in Development and QA environment.
• Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.
• Involved in Performance tuning/bottlenecks and eliminated the bottlenecks to optimize the performance.
• Monitor all production issues and inquiries and provide efficient resolution for same.
• Providing possible resolutions to data issues and document the same for reference.
• Schedule and monitor the sessions workflows using Informatica workflow manager and workflow monitor.
• Scheduling meetings with business users and Offshore team to ensure the status of the activities and tasks.
• Used Unix commands to handle the flat files, Editing Parameter files, check the folders size etc.
• Performing Code reviews with offshore team and make sure the solution is up to the standards.

Environment: Informatica 10.x, Oracle, Flat files, Sql Developer, UNIX shell scripting.