We provide IT Staff Augmentation Services!

Sr Etl Informatica Developer Resume

Milwaukee, WI

SUMMARY:

  • Around 6 years of experience in Information Technology.
  • Exposure to Informatica PowerCenter, IDQ, Master Data Management, Data Warehousing, Teradata, SQL, Oracle and Teradata.
  • Good understanding of Data Warehousing and BI concepts.
  • Strong UNIX Shell scripting and Perl scripting experience.
  • Extensive use of job scheduling tools like Autosys and Control - M.
  • Exposure to all Informatica PowerCenter client tools.
  • Good skills in developing complex mappings and workflows using Informatica PowerCenter and Informatica Cloud.
  • Working closely with AWS to migrate the entire on-prem Data Centers to the cloud using VPC, EC2, S3, EMR, RDS, Splice Machine, Diyotta, Aurora, IoT and DynamoDB services.
  • Good understanding of Data warehousing, Dimension Modeling and RDBMS concepts.
  • Expertise in Informatica IDQ, data profiling, scorecards and troubleshooting on MDM/IDQ components.
  • Leading the initiative to evaluate Big Data vendors and Cloud vendors and implementing them by providing technical leadership and by following best practices in the industry.
  • Worked with various transformations in IDQ .Experience in development of mappings in IDQ to load the cleansed data into the target table using various IDQ transformations.
  • Experience in Data Modeling, Star Schema, Snowflake Schema, Slowly Changing Dimensions, Fact tables, Dimension tables, Normal forms, OLAP and OLTP systems.
  • Having strong hands on experience in extraction of the data from various source systems like SQL Server, DB2, Oracle, MySQL, Netezza, Flat Files, SFDC, XML and Teradata.
  • Extensively worked on Mainframe/Unix and Informatica environments to invoke Teradata Utilities and file handlings.
  • Experience in writing Complex SQL queries, stored procedures and functions using PL/SQL.
  • Involved in Performance tuning of mappings and sessions.
  • Expertise in using both Agile & Waterfall Methodologies effectively.
  • Focused, hardworking, self-motivated, effective team player and Leadership qualities.

TECHNICAL SKILLS:

ETL Informatica: PowerCenter 10/9.6.1/9.5.1/8.6.1/7.1.1, Informatica Cloud

OS: Windows, Unix/Linux

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/2008/2014/2016, Teradata

Programming: SQL, PL/SQL, UNIX, XML

Schedulers: Autosys, Control-M

WORK EXPERIENCE:

Confidential, Milwaukee, WI

Sr ETL Informatica Developer

Responsibilities:

  • Worked with Master Data Management (MDM) team to load data from external source systems to MDM hub.
  • Utilization of Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
  • Worked with different caches such as Index cache, Data cache and Lookup cache
  • Performed error handing using session logs.
  • Involved in Performance tuning for sources, targets, mappings and sessions.
  • Migrated mappings, sessions, and workflows from development to testing and then to Production environments.
  • Integrating Big Data Hadoop into the existing Data Warehouse Stack by identifying the gaps.
  • Establishing security standards for Hadoop environment.
  • Driving Big Data - Hadoop Solutions (using Map-Reduce, Hive, Pig, Sqoop, Spark, HBase, Navigator, Oozie and MongoDB)
  • Worked on upgrading Informatica from version 9.6.1 to 10.1.
  • Developed UNIX Shell scripts to execute the workflows using PMCMD utility and used Autosys scheduler for automation of ETL processes.

Environment: Informatica Power Center 9.6.1/10.1, Informatica Data Quality(IDQ) 9.6.1, Informatica MDM 9.5, Oracle 11g, Teradata, Autosys, SQL, PL/SQL, UNIX, MS SQL Server 2016.

Confidential, Princeton, NJ

ETL Informatica Developer

Responsibilities:

  • Working with business to understand and document the requirements.
  • Created the Control-M jobs for scheduling various workflows.
  • Development and tuning of Informatica codes using partitioning, bulk loading, etc.
  • Wrote PL/SQL, Shell, SQL, and Informatica scripts as needed.
  • Performed Unit testing and maintained test logs and test cases for all the mappings.
  • Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
  • Production Support and bug fixes using JIRA system.

Environment: Informatica Power Center 9.6.1, Oracle, Teradata, SQL Server 2008, DB2, SQL Loader, Flat Files, Unix, Control-M.

Confidential, Melbourne, FL

Informatica Developer

Responsibilities:

  • Developed ETL programs using Informatica to implement the business requirements.
  • Created shell scripts to fine tune the ETL flow of the Informatica workflows.
  • Fixed the invalid mappings and troubleshoot the technical problems of the database.
  • Design Informatica ETL processes for loading Data warehouse tables and create STM documents according to design requirements.
  • Designing and developing Oracle PL/SQL and UNIX shell scripts.
  • Involved in migrating Informatica objects from Development and Test to Production using deployment groups.

Environment: Informatica PowerCenter 9.1, Oracle 11g, SQL Developer, Windows, Unix/Linux, PL/SQL.

Confidential

Informatica Developer

Responsibilities:

  • Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
  • Actively participating in agile process development style like attending scrum meeting
  • Creating datamaps using power exchange.
  • Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
  • Developed UNIX Shell Scripts for scheduling the sessions in Informatica.
  • Written UNIX scripts to transfer the data from sources to the target warehouse.

Environment: Informatica PowerCenter 8.6.1, Power exchange 8.6, SQL Query Analyzer 8.0, Oracle 10g, SQL Developer, Windows, Unix/Linux.

Confidential

Jr Informatica Developer

Responsibilities:

  • Monitored the ETL jobs on regular basis. In case of any failure, performed root cause analysis and recovered the job.
  • Developed Informatica mappings to implement migration activity for client, decreasing processing time by 30% and reduced the burden on the database server up to 60% to meet the SLAs.
  • Experienced in Tuning Informatica Mappings to identify and remove processing bottlenecks.
  • Automation and scheduling of UNIX shell scripts and Informatica sessions and batches.
  • Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, Informatica Power Center 8.6.
  • Scheduled Informatica workflows using Informatica Scheduler to run at regular intervals.

Environment: Informatica Power Center 8.6, Oracle 10g, MS SQL Server 2008, MS Access, MS Excel 2008, SQL Developer, Windows, Unix/Linux.

Hire Now