We provide IT Staff Augmentation Services!

Informatica Lead Developer Resume

Irving, TX

EXPERIENCE SUMMARY:

  • 11+ 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.
  • Created High level Technical Specification, User level requirement documentation and Low level design procedural documents for the ETL process and standards.
  • Expertise in Unit testing of mappings, sessions and created documents such as Test Case, Test script document, Test result document.
  • Expertise in different types of loading like Normal and Bulk loading challenges. Involved in Initial Loads, Incremental Loads, Daily loads and Monthly loads.
  • Knowledge in connecting to sources with Informatica Power Exchange.
  • Comprehensive working knowledge of Oracle 10g/9i, Teradata V2R12
  • Expertise in production support activities like fixing the abends, root cause analysis for recurring abends, working on User queries, Informatica Maintenance, Teradata upgrade, Moving applications from Tivoli Workload Scheduler to Autosys Scheduler, Enhancements to existing applications.
  • Extensively used Business Objects for testing reports in the process of preparing for User Acceptance Testing.
  • Involved in helping the reporting team with Business Objects reports and data issues.
  • Knowledge in OLAP tools Siebel Analytics 7.8 and Micro strategy
  • Good knowledge and understanding of Scheduling tool Autosys, IBM Tivoli scheduler (TWS) and Control-M.
  • Experience in Agile Methodology (Scrum technique), involved in Scrum meetings, Sprint planning, Sizing user stories and participate in retrospective meetings.
  • Strong Team building and mentoring skills and excellent Team leadership capability.

TECHNICAL SKILLS:

DW ETL Tools: Informatica PowerCenter 9.x/8.x/7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Informatica PowerExchange 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, 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

Responsibilities:

  • 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.
  • Worked with DBA to fine tune complex SQL’s, do regular Stats on the tables, drop and recreate indexes to decrease run times of various Informatica mappings which process large volume of data.
  • Extensively used the scheduling tool to schedule jobs and their dependencies in production.
  • Responsible for migrating the developed mappings and workflows from development to integration and to production.
  • Involved in production support activities including monitoring loads, resolving exceptions and correcting data problems.
  • Analysis of the defects raised by clients and fixing the issues in informatica ETL mappings.
  • Root cause analysis of production defects.

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

Data Specialist Informatica

Confidential, Jacksonville, FL

Responsibilities:

  • 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

Software Engineer

Confidential, Mason, OH

Responsibilities:

  • 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.
  • Created UNIX shell scripts according to requirements.
  • Created Pre-SQL and Post-SQL in both Transformations and Sessions Properties.
  • Created Partitions through the session wizard in the Workflow Manager to increase the performance. By maximizing data through concurrent processing of specified Partitions using Simple Pass Through, Key Range
  • Involved in database performance tuning by Analyzing table and adding Hints to the SQL Queries.
  • Involved in migrating the mappings and workflows from Development to Testing and then to Production environments.
  • Prepared documentation describing development of mappings, coding, testing and designing of Autosys Jobs
  • Involved in post-production support and enhancements.

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

Hire Now