EXPERIENCE SUMMARY:

• 13+ years of experience as a Tech Lead, Informatica Developer in developing large - scale Data Warehouse and Client/Server Applications, including Data Profiling, Data Migration, Data Modeling, Business Process, Design and Development, Integration and Testing, Database Programming, SDLC, Project Management and Production Support.
• Experience in the Data Warehousing implementations for Insurance, pharmaceutical, HealthCare, Banking and Financial domains.
• Experience in complete Software development life cycle (SDLC) with a strong background in Design/Modeling, database development and implementation of various business intelligence and data warehouse/DataMart projects that cover gathering Business Requirements, Development, Implementations and Documentation.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like ERwin data modeler, Power Designer, Embarcadero E-R Studio and Microsoft Visio.
• Strong experience working with conceptual, logical and physical data modeling considering Metadata standards. extensive experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Informatica Power Center v 9.x/8.x/7.x Suite.
• Experience in massive data profiling using Informatica Data quality (IDQ). Worked on Address Validator, Match, Merge, Key generator, Expression, Filter, Consolidation, Standardizer and Association transformations for Source data profiling.
• Experience in Exporting IDQ mapplets to Informatica PowerCenter.
• Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inmon) - Star schema, Snowflake schema, SCD, Surrogate keys, and Normalization/Denormalization
• Experience in integration of various data sources like Oracle, DB2, COBOL copybooks, and SQL Server, Flat Files, Excel, and XML files.
• Worked on Slowly Changing Dimensions (SCD) and its implementation (Type 1, Type 2, and Type 3) to keep track of historical data.
• Strong Quality Assurance and debugging skills in ETL Process.
• Proficient in Toad, SQL navigator, and UNIX Shell Scripting.

TECHNICAL SKILLS:

• DW ETL Tools: Informatica PowerCenter 9.x/8.x/7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Informatica Power Exchange 8.6, Informatica Data Quality(IDQ) 9.6, Informatica Cloud
• Data Modeling tools: Erwin Data Modeler 9.1/8.2/7.2/ 7.1, Erwin Model Manager, ER Studio
• Data Management: Reltio cloud MDM, Informatica MDM 9.6
• OLAP/BI tools: Business Objects XI 3.1/4.0/6.5, Siebel Analytics 7.8, Micro strategy, and Tableau 10
• Database: Oracle 10g/9i, MS SQL Server 2000, IBM DB2 8.2, Greenplum, and Teradata V2R12, Maria DB/MySQL
• Scheduling Tools: Autosys, IBM Tivoli workload scheduler (TWS), and Control M
• Operating Systems: Microsoft Windows 7/XP and UNIX.
• Other Tools: Toad, SQL Developer, WinSQL, Visio, Microsoft Office, Putty, MFT

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Informatica ETL Developer

Responsibilities:

• Analyze the client requirements and then design, test, and develop ETL methods to meet business needs for EODS data warehouse project.
• Consults EODS business unit associates by written and/or oral communication on inquiries concerning existing or proposed business requirements and convert those business requirements into ETL Informatica design.
• Researches, designs, defines, develops, tests, documents and implements ETL informatica code or changes to existing ETL informatica code for EODS Data Warehouse Project following Confidential & Southern Financial Group (W&SFG) standards.
• Utilizes Informatica PowerCenter effectively to develop ETL Mappings, Sessions, Mapplets, Worklets and Workflows.
• Writes and Develops SQL Scripts, Stored Procedures in T-SQL and in corporate them in Informatica ETL Mappings and Workflows to develop Data Quality Framework for EODS Data Warehouse Project.
• Performs comprehensive end to end Unit and SIT testing for the ETL Workflows, Sessions, and Mappings built as per the ER data model and provided requirements.
• Handles multiple assignments with multiple deadlines simultaneously.
• Performs other ETL Informatica development duties for different projects as assigned by management.
• Design, develop and implement software applications, create system procedures and ensure that the developed applications function normally.
• Maintain and modify programs, make approved changes by amending flow charts, develop detailed programming logic, and coding changes.
• Write source code, prepare test data, tests and debug programs, revise and refine programs to improve performance of the application software.

Technologies/Environment: Informatica Power Center 10.1, ER Studio, Tableau BI, CA Workload ESP, Informatica Data Quality (IDQ) 10.1, SQL, PL/SQL, Oracle 12c

Confidential, IRVING, TX

Informatica Lead Developer

Responsibilities:

• Coordinated with Business Analysts to understand the business requirements and implemented the same into a functional Data warehouse design.
• Played the role of a Program Technical Lead/ETL Architect and was responsible for designing the ETL Strategy & Architecture of the Project.
• Developed ETL technical specs, Visio for ETL process flow and ETL load plan, ETL execution plan, Test cases, Test scripts etc.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, Sequence Generator and SQL.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Responsible for migrating the developed mappings and workflows from development to integration and to production.
• Experience in creating and effectively executing deployment plan to move all the objects, tables, mappings, workflows, SQL scripts, etc. to production.
• Created UNIX shell scripts according to requirements.
• Performed massive data profiling using Informatica Data quality(IDQ), Worked on Address Validator, Match, Merge, Key generator, Expression, Filter, Consolidation, Standardizer and Association transformations for Source data profiling.
• Experience in Exporting IDQ mapplets to Informatica PowerCenter

Technologies/Environment: Informatica Power Center 9.6.1, Oracle Data Modeler, Maria DB, My SQL, UNIX Shell Scripts, Putty, WinSCP, Microstrategy, Control-M, MFT, Informatica Data Quality (IDQ) 9.6, HADOOP, PGP

Confidential, Plano, TX

Technology Lead

Job Description/Roles:

• Played the role of a Program Technical Lead/ETL Architect and was responsible for designing the ETL Strategy & Architecture of the Project.
• Participated in the Project full life cycle from development to production and in gathering the required business documents for ETL development.
• Coordinated with Offshore on Project Deliverables including Development, QA and Deployment
• Designed the Data model for OLAP database system and created DDL scripts for implementing Data Modeling changes using Erwin.
• Involved in Dimensional modeling of new requirements for effective Business Objects reporting and dashboarding.
• Responsible for preparing and delivering high level and detailed level design documents
• Responsible for reviewing the code developed by the peers before delivering the code.
• Train and Manage developers, advising other groups in organization on Informatica development, data warehouse development and ETL development best practices.
• Used Power Exchange to source copybook definition and then to row test the data from data files etc.
• Involved in Unit Testing, User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Experience in creating and effectively executing deployment plan to move all the objects, tables, mappings, workflows, SQL scripts, etc. to production.

Technologies/Environment: Informatica Power Center 9.6.1, Oracle 12c, SQL and PL/SQL, DB2, GreenPlum, Autosys, Harvest, Power Exchange Navigator 8.6, Erwin 4.1, Informatica Data Quality (IDQ) 9.6, SQL Developer

Confidential

Data Specialist Informatica

Job Description/Roles:

• Monitoring and tracking the applications as per the schedule run.
• Analysis on production job failures.
• Reloading of applications run and need to make sure reloading process is completed
• Restarting of applications run and need to make sure restart process is completed
• Catching up for the applications and need to make sure catch up process is completed
• Validate the data loaded into database.
• Provide the status report for all the application monitoring, tracking status
• Communication with SOR, Downstream users if any delays are happened
• Root cause analysis for recurring abends
• Involved in verifying applications to move from Tivoli Workload scheduler to Autosys scheduler.
• Participating in planning and executing portion of Teradata upgrade, Hardware Upgrade.
• Developed UNIX shell script newpmcmd.sh to run the PMCMD commands in UNIX environment to run the workflows using the Autosys scripts.
• Created, launched & scheduled Workflows/sessions by developing the Autosys Jobs by generating the JIL files in UNIX Environment.
• Supported the issues in Microstrategy BI Reports.

Technologies/Environment: Informatica PowerCenter 8.1/8.6, Informatica Power Exchange Navigator 8.6, Flat Files, SQL Server, DB2, Autosys, IBM TWS, Microstrategy, UNIX, and Teradata V2R12

Confidential

Software Engineer

Job Description/Roles:

• Used to interact with the Business Users/Analysts and Data Architects to understand the business requirements of the application.
• Responsible for extracting the data from Siebel OLTP source systems, transforming and loading data into Siebel Data warehouse (SRMW) target according to client requirements.
• Involved in extracting the data from Oracle sources, transforming and loading data into Flat files, and Mainframe datasets according to client requirements.
• Involved in creating Mappings, workflows, Transformations, and workflow tasks.
• Used Mapping Parameters/Variables and Workflow Variables to implement Object orientation techniques and facilitate the reusability of code.
• Created and scheduled workflows, Performed Debugging and Performance Tuning of Mappings and sessions.
• Involved in Unit and integration testing of the mappings.
• Used Debugger to test the mappings and to fix the bugs.

Technologies/Environment: Informatica Power Center 8.1, Business Objects 6.5, Oracle 9i, SQL Server 2005, IBM DB2 8.2, Siebel Analytics 7.8 (DAC), Windows XP, and UNIX