SUMMARY:

• 7+ years of Professional experience as ETL developer in Data Warehouse work environment.
• Proficient with Agile and Waterfall development methodology.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica PowerCenter.
• Heavily worked on PowerCenter client applications - Designer, Workflow Manager, Workflow Monitor, Repository Manager and developed workflows, worklets, mappings and mapplets.
• Good understanding of Informatica Intelligent Cloud Services (IICS) for Data Synchronization and Data Replication.
• Installed and configured of Informatica services and PowerCenter client tools.
• Performance tuned ETL processes using Partitioning and Pushdown Optimization techniques.
• Hands on experience on various data quality transformations for data cleansing.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Experience in Business intelligence report tools like OBIEE, Cognos BI Suite for warehouses and data marts.
• Well versed in UNIX shell scripting, Perl scripting.
• Worked with relational databases like Oracle, DB2, SQL Server and Teradata.
• Experience in PL/SQL (Stored Procedures, Triggers, views, indexes, constraints, synonyms, partitioning).
• Performed various testing activities like Unit Testing, Integration- System Testing, Regression Testing, and User Acceptance Testing.
• Experience in production support 24x7 work environment. Resolved the issues, defects and Incident tickets.
• Excellent analysis, debugging and trouble-shooting skills.
• Practical knowledge of Data warehouse and Data modeling concepts - Star Schema, Snowflake Schema.
• Excellent communication, co-ordination, presentation and documentation skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter, Data Quality, Power Exchange, and Informatica Cloud (IICS)

Incident Management: ServiceNow, Remedy, and SharePoint Incident Management

App Server: IBM Websphere 8, Oracle Weblogic Server 11

Databases: Oracle 12c,DB2 v9, MySQL 5.0, SQL Server 2012, Teradata

DBMS Tools: DBVisualizer, TOAD, SQL Developer, SQL Plus, Teradata SQL Assistant

Job Scheduler: AutoSys, Linux crontabs, Control M, IBM TWS, CA WA ESP

Reporting Tools: Business Objects, Oracle Business Intelligence, Crystal Reports, Cognos BI

Scripting/ Languages: PL/SQL, Unix Shell Scripting, Perl, Ruby, XML, Java/J2EE

Operating System: Linux, Windows Server, Windows 10

Others/Tools: Putty, WinSCP, Erwin, JIRA, AWS, IBM’s RTC, GitHub, SoapUI, Rational Rose, Microsoft Visio, CICS Explorer, Jenkins

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, Ohio

Sr. ETL Developer

Roles and Responsibilities:

• Tuned Informatica mappings and sessions using techniques like partitioning and pushdown optimization.
• Created labels, queries and dynamic deployment group for code migration to higher environments.
• Developed mappings, mapplets, worklets and workflows using Designer and Workflow Manager and monitored them using Workflow monitor.
• Wrote automated unit test cases for many mappings in RubyMine.
• Worked on Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations for data cleansing.
• Supported implementation of data profiling, creating score cards, reference tables and documenting Data Quality metrics/dimensions like Accuracy, completeness, duplication, validity, consistency.
• Wrote scripts for job scheduling and created Changeman packages for migration for ESP scheduler.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Worked heavily with Oracle, DB2, Teradata databases and flat files for ETL processes.
• Resolved code defects, production issues and handled Incident tickets.
• Investigated and fixed the bugs occurred in the production environment and provided on-call support.
• Created and Maintained process flow documentation.
• Modified existing mappings for enhancements of new business requirements.
• Extensively used Linux commands and shell scripts for file transfers, file manipulation and workflow execution.

Environment: Informatica PowerCenter 10.2.0, IDQ, SQL Developer, Teradata SQL assistant, Squirrel, Linux, Perl and Shell scripts, Oracle12c, DB2, Teradata, Putty, PL/SQL, RTC, GitHub, HP Quality Center, ESP scheduler, RubyMine, SoapUI, IBM UrbanCode Deployment, Jenkins.

Confidential, Auburn Hills, MI

Sr. Informatica Developer

Roles and Responsibilities:

• Took part in JAD sessions to define the Business requirement specifications and Functional specifications
• Developed complex mappings by importing sources and targets and using various transformations.
• Created workflows using various tasks and developed reusable components for automation.
• Reviewed ETL Mappings, Sessions, etc developed by team members.
• Used Mapping Variable and Parameters to filter the daily data from the source systems.
• Extensively used PowerCenter command line utilities such as pmcmd, Pmrep embedded in shell scripts to perform various administrative tasks such as migrations, repository backup scripts, start/stop scripts, etc.
• Created database Joins, Triggers, Stored Procedures and Functions.
• Re-engineered many existing mappings to support new/changing business requirements.
• Designed multi dimensional Star schema, generated the database scripts, E-R diagrams using ERWIN.
• Performed unit testing, system integration testing, and supported user acceptance testing.
• Created Technical Design Specifications, Unit test document based on functional design specifications provided by Business Analyst.
• Prepared migration document to move the objects from development to higher environments.
• Used JIRA-Agile project management tool to plan, track and manage progress of story cards and also track bugs and requests.

Environment: Informatica PowerCenter 9.6.1, SAP FICO, SQL Developer, Toad, Unix, Windows 7, Perl and Shell scripts, Oracle 11g/12c, Microsoft Visio, Putty, PL/SQL, JIRA, iServe, Tivoli Workload Scheduler

Confidential, Detroit, MI

Sr. Informatica Developer

Roles and Responsibilities:

• Designed and developed ETL Processes based on business rules, job control mechanism using Informatica PowerCenter.
• Supported Informatica upgrade 9.1 to 9.6.1 by creating pre-upgrade checklist, upgrading Informatica server, client tools, repository contents, and by performing post-upgrade tasks.
• Performed Informatica, non-Informatica code migration between environments (DEV/QA/PRD).
• Handled huge volumes of data at Enterprise Data Warehouse about 25 Tera Bytes.
• Worked extensively on complex mappings.
• Used workflow monitor to monitor the jobs, review session/workflow logs and used Informatica debugger to identify issues in mapping execution.
• Created data maps using Power Exchange Navigator for the sources and targets.
• Used Power Exchange Data Change option (CDC) to capture modified records.
• Worked on Informatica Data Quality (IDQ) to perform data profiling and data cleansing.
• Developed reusable transformations, mapplets, sessions, and worklets to make code modular and reusable
• Tuned SQL statements, Informatica mappings, used Informatica parallelism options to speed up data load.
• Developed PL/SQL procedures and used them as a Stored Procedure Transformation.
• Assisted in designing Logical/Physical Data Models.
• Integration of various data sources like Oracle, SQL Server, XML and Flat Files, DB2.
• Created Unit Test cases and captured test Results, developed and tested all the Informatica mappings, sessions and workflows.

Environment: Informatica Power Center 9.1/9.6.1, Power Exchange, IDQ, Toad, Oracle 10g/11g, Mainframes, SQL Server 2012, SSIS, PL/SQL, DB2, OBIEE, LINUX Shell script, Perl Scripting.

Confidential

Informatica Developer

Roles and Responsibilities:

• Worked on end to end project implementation starting form analysis, design, development, testing, deployment and maintenance of project.
• Created reusable transformations to clean the data, which were used in several mappings.
• Worked on power exchange to create data maps, pull data from mainframe, and transfer into staging area.
• Developed and tested stored procedures, functions and packages in PL/SQL.
• Extracted data from various sources like MS SQL Server 2008, DB2, flat files, Excel spreadsheets, Oracle and XML files and loaded into the oracle database.
• Involved in Production Support, analyzed and resolved job failures and data issues.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing Error Handling method and Recovery mechanisms.
• Worked with Informatica Administrator to setup project folders in development, test and production environments.
• Worked on Teradata utilities like BTEQ, Fast Load, MultiLoad, FastExport and TPump.
• Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows).
• Worked with the Quality Assurance team to build the test cases to perform unit, Integration, functional and performance Testing.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.

Environment: Informatica Power Center 8.6/9.1, Autosys, Netezza, Power Exchange 8.1, IDQ, Oracle 10g, Teradata, SQL Assistant, SQL Server 2008, PostgreSQL, SSIS, PL/SQL, SQL, DB2, UNIX, Business Objects 5.1, Python, Ruby, Shell script.