We provide IT Staff Augmentation Services!

Informatica Etl Developer Resume

Atlanta, GA

Summary:

Over 21+ years of professional experience in Software Development Life Cycle (SDLC), Data warehousing and the implementation of various Business applications. Over 12+ years of Informatica ETL Development. Have a wide variety of experiences in various capacities across different industries such as Telecom, Sales, Hire Purchase, Manufacturing, Finance, Ship Board Management, Airline, Credit Cards and sensitive data Industry.

  • Extensive working knowledge in Data warehouse ETL activities using Informatica9/8.6/8.5/8.1/7.1/6.2.
  • Working knowledge of Informatica Administration like installation, troubleshooting, maintaining user/group privileges and migrating objects from Dev to QA and QA to Production using Repository Manager export/import.
  • Proficient in Oracle 10g / 9i / 8i / 7.x / 6.x, OLAP/OLTP, Data Mart, Data warehousing, SQL Server, Teradata and Oracle Data Base Administration.
  • Proficient in Data warehouse ETL activities using SQL, PL/SQL, PRO*C, SQL*LOADER, C, Data structures using C, Unix scripting, Python scripting and Perl scripting.
  • Proficient with Star schema and Snowflake schema Data warehouse models using Ralph Kimball/ W. H. Inmon methodologies.
  • Working knowledge in Oracle Backup and recovery, imports and exports, performance-tuning, creation of Oracle objects, analyzing objects and monitoring and estimating the table space for oracle tables and indexes.
  • My work authorization is US citizen.

Technical Environment

  • Hardware:
  • SUN Sparc Ultra-enterprise Server, HP9000 Series UNIX server, SGI3200 UNIX server and IBM RISC 6000 Iris server.
  • Database:
  • Oracle 10g/9i/8i/7.x/6.0/5.0
  • MS-Access
  • Teradata
  • SQL Server
  • Data warehouse and WEB Development Tools:
  • Informatica PowerCenter 8.1/7.1/6.2
  • Python, JAVA, HTML, Servlets and JSP.
  • Client Server Development Tool, Programming Languages and Designing tools:
  • UNIX, Sun Solaris-OS, AIX, Windows vista/ Windows XP/ Windows 98/ Windows95, MS-Windows/MS-DOS
  • Developer 2000 (ORACLE FORMS 4.5 & ORACLE REPORTS 2.5), SQL*Plus, PL/SQL, SQL*FORMS 3.0, Pro*C, SQL Loader and Oracle database Triggers and packages.
  • C, Pascal, Data structures and algorithms using C.
  • Unix Shell scripts
  • Python scripts
  • Linux scripts
  • Perl scripts
  • SQL Navigator, Microsoft Query, TOAD & Oracle Procedure Builder.
  • Visual Source Safe (VSS), PVCS (Polytron Version Control System) and DTS (Defect Tracking System)
  • ERwin
  • Microsoft Visio

Education

  • Post Graduate Diploma in Software Technology (PGDST)
  • Bachelor of Science (BSC)
Extracurricular activities
  • Member of ToastMasters Alpharetta club for improving my leadership skills.
  • Teaching Hindi language to kids at Balvihar.

Work Experience

Confidential, Atlanta, GA
(Oct 2011 till present)

The following tasks are accomplished in this project: -

  • Working as an ETL Lead implementing ETL processes to design/develop/test/install/migrate/troubleshoot various ATT mappings.
  • Designed the Data warehouse using Ralph Kimball methodologies.
  • Created oracle tables/indexes as required for the CATS/OTM data in the data warehouse.
  • Installed DAC and scheduled Informatica jobs form it.
  • Led 2 on shore and 4 offshore developers on the project.
  • Performed code reviews for my team.
  • Provided guidance to the team for performance tuning/ troubleshooting.
  • Made sure the team delivered the deliverables, reviewed their codes, followed the ETL standards and helped them whenever they were looking for help.
  • Designed and developed entire CATS datawahouse and OTM data warehouse for ETL implementations.
  • Designed and developed the error handling routines.
  • Designed, developed, unit tested and documented various type 2 mappings like Parts/Locations/Project.
  • Developed SQL, PL/SQL programs and performance tuned the programs.
  • Performed performance tuning of Informatica maps for more efficient loads.
  • Developed efficient sql, pl/sql programs and also used with/merge statements for efficient on the fly upsert strategies.
  • Developed OBIEE RPDs and create reports using BI Answers.
  • Developed BI reports with mapping capabilities using Oracle map builder integrated in OBIEE.

Confidential, Atlanta, GA
(Feb 2011 till Aug 2011)

The following tasks are accomplished in this project: -

  • Working as a Lead ETL Developer implementing ETL processes to design/develop/test/install/migrate/troubleshoot various Alere mappings.
  • Designed the Data warehouse using Ralph Kimball methodologies.
  • Developing the source deletes logic for the entire warehouse.
  • Designed, developed, unit tested and documented various type 2 mappings for the Apollo Stage five area.
  • Developed SQL, PL/SQL programs and unit tested them.
  • Mentored other developers on Informatica 8.6 and reviewed their code.
  • Performed performance tuning of Informatica maps for more efficient loads.
  • Designed and developed complete ETL solutions on different projects.

Confidential, Atlanta, GA
(Feb 2009 till Feb 2011)

The following tasks are accomplished in this project: -

  • Working as an ETL Lead/Informatica Admin implementing ETL processes to design/develop/test/install/migrate/troubleshoot various BioSense processes to collect epidemic details across the nation.
  • Managing two other resources on this project.
  • This Data warehouse design was developed using star schema/ Ralph Kimball methodologies.
  • Helping other Informatica resources trouble shoot any problems they might have.
  • Assigning work to other resources and making sure the project is delivered on time.
  • Installation of Informatica 8.5 on staging/ LAB box.
  • Troubleshooting of various errors while installation/ production run/ Data issues.
  • Design modifications of the BioSense Data model using Erwin.
  • Loading XML messages received from various hospitals across the nation into Database using JMS JBOSS queues/Informatica.
  • Added new maps like Message_Observation to the BioSense process.
  • Fixing bugs on different mappings to have a more accurate data for the next BioSense release.
  • Used Informatica’s built in version control system for source code management.
  • Used source side, target side and full pushdown optimization to improve session performance.
  • Involved in Informatica Admin work like installation, migrating workflows and mappings from Dev to staging/ Lab Box/Production using Repository Manager and managing user and group privileges on Informatica Folders.
  • Performance tuning various maps and SQL, PL/SQL programs to have a better throughput of data received from various hospitals across the nation.
  • Developed Korn Shell scripts to move, archive source/ target files.
  • Developed some PL/SQL procedures for mass deletes/updates.
  • Have some exposure to OBIEE.

Confidential, Alpharetta, GA
(Nov ’08 till Dec ‘08)

The following tasks are accomplished in this project: -

  • Worked as an ETL Lead implementing ETL process to fix the C2O site error fix.
  • Designed, developed, unit tested Sales Promotions dimension maps.
  • Designed complex star schema architecture for Channel Lead Report from Channel Lead Report OLTP schema.
Confidential, Alpharetta, GA (Jun ’05 till Oct ‘08)

The following tasks are accomplished in this project: -

  • Implemented ETL process for CROSS mappings for source data received from courts in Texas Brazoria, Colorado Denver, Texas Elpaso, Kentucky and Nebraska using Informatica PowerCenter 8.1.
  • Delegated tasks to offshore team and made sure they were completed on time.
  • Performed source data analysis before development and interaction with Business Analysts.
  • Created Technical specification and Source to Target mapping documents.
  • Used various maps/session performance tuning techniques including parallel pipeline session partitioning.
  • Designed and developed ETL architecture for Real Property database in 3NF.
  • Performed historical/incremental loads on Real Property database.
  • Developed reusable transformations, mapplets and worklets to reduce development efforts whenever possible.
  • Used First Logic Name and Address parsers in lot of maps.
  • Developed and unit tested reusable transformations for name and address parsing.
  • Developed CROSS error handling logic/ reprocess generic map to load manually rectified error data for any court.
  • Led a team of four other developers and helped them with technical issues.
  • Developed slowly changing dimension mappings.
  • Developed complex LANDFLIP report for FBI to give them a list of property owners who flipped their properties to minimize taxes.
  • Developed Death Master report to let the Government know about the Dead people in the country to avoid SSN frauds.
  • Developed Unix scripts to automate the load process, restart from failure points, Unix workflow scripts to be called from ControlM scheduler and move, archive source/ target files.
  • Developed various transformations in the mappings like Source Qualifier, Expression, Union, Filter, Sorter, Aggregator, Joiner, Lookup, Router, Sequence generator, Transaction Control, Update Strategy, Stored procedure, External Procedure and Normalizer transformations.
  • Unit tested and peer tested the mappings and workflows and fixed the bugs.
  • Designed and developed Bankruptcy customer outputs (PADR/Express financial) and was responsible in providing them monthly output files promptly in required output formats.
  • Encrypted and secured FTP the sensitive public data to both internal and external customers.
  • Used the $$PushdownConfig Mapping Parameter to do source-side, target-side, or full pushdown optimization at different times, depending upon the database workload.
  • Debugged maps using Debugger and Transformation’s verbose data.
  • Developed command tasks, email tasks, decision tasks and timer tasks in Workflow manager.
  • Created Unit testing, QA migration and Production Turnover documents.
  • Involved in Informatica Admin work like migrating workflows and mappings from Dev to QA and QA to Production using Repository Manager and managing user and group privileges on Informatica Folders.
  • Followed development standards like ChoicePoint’s object naming conventions, short cuts to sources, targets, source anchors, target anchors and a brief documentation on each transformation that I developed.
  • Involved in production support for nightly loads.

Confidential, Atlanta, GA
(Oct \'03 till Jun ‘05)

The following tasks are accomplished in this project: -

  • Worked as a Sr. ETL Developer implementing ETL process for CCDS migration (Also known as TrueNorth) using Informatica PowerCenter/PowerMart 7.1.
  • Designed, developed and unit tested type 1 and type 2 mappings to load the data in CCDS star schema.
  • Developed and unit tested the main Accounts fact table of this data warehouse.
  • Developed an accounts persistent cache mapping to improve the performance across all other type 2 mappings.

Hire Now