We provide IT Staff Augmentation Services!

Etl Informatica Developer Resume

5.00/5 (Submit Your Rating)

Reston, VA

SUMMARY

  • IT professional with 7+ years of diverse experience in Design, Development and Maintain ETL process using ETL tools, possessing superior analytical skills and the ability to meet deadlines
  • Extensively used Informatica Repository manager, Power centre Designer, Informatica Data Transformation Studio.
  • Experience with Talend big data platform for data management and RedShift and other services
  • Involved in implementing AWS cloud solutions using S3, EC2, EMR, Lambda, SQS, SNS, Athena, RDS and CONFLUENCE
  • Proficient in Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse.
  • Good experience in Scaled Agile Environment.
  • Excellent knowledge in creating source to target mapping, edit rules and validation, transformations based on business rules.
  • Involved in all stages ETL - requirement gathering, designing and developing various mappings, unit testing and integration testing
  • Experience in analysing the bugs and interacting with developers and team members for fixing the defects.
  • Used various database client tools like TOAD, SQL developer, DBeaver, Teradata SQL Assistant to access/create/change database objects and create scripts.
  • Automation and scheduling of Informatica jobs using AutoSys
  • Excellent written and verbal communication skills, good analytical reasoning and ability to learn quick and high adaptability to new tools and technologies.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica Power Canter 10.4.0/9.6.1/9.5.1/9.1 , Talend 6.5.1, Informatica Power Exchange

Data Modeling: ERWIN 8.2/7.x/4.x.

Databases: Oracle 12c/11g/10g,Teradata, AWS RDS, Hive, RedShift, Glue, MongoDB, Cassandra and cloud.

Database Utilities: Toad, SQL*Loader, SQL Developer, Toad Data Point,DBeaver 3.8.2

Scheduling Tools: Autosys, CONFLUENCE

Helpdesk Tools: JIRA, Confluence, HP Quality Canter

Programming: SQL, PL/SQL, Unix Shell Scripting

Web Technologies: HTML, XML,Amazon AWS tool set

Operating Systems: Windows 2000/NT, Win XP, Win 7, Win 8, Unix

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

ETL Informatica Developer

Responsibilities:

  • Extensive experience working in an Agile development environment
  • Involved in writing procedures and functions in Redshift
  • Worked with JIRA for tracking issues, creating the technical user stories and tasks.
  • Worked with Business Analyst to Gather business requirements.
  • Worked on Creating S3 buckets and folders in theAWSenvironment to store files,
  • Extracted the data from different sources like oracle, glue and hive loaded to redshift.
  • Worked on creating the Step Functions in AWS
  • Worked on multiple ETL tools (Informatica /Talend) to load the data into Oracle/Netezza as part of RDW Retirement.
  • Worked on creating the test scenarios for Unit Testing.
  • Processed the Underwriting Data using Talend Big Data on AWS and load the data to Hive and RedShift
  • Estimates and planning of development work using Agile Software Development.
  • Created Complex mappings using Unconnected and connected Lookups and Aggregate and Router transformations for populating target table in efficient manner.
  • Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problems.
  • Developed SQL Overrides for the Source Qualifiers Based on the Business Requirements.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Worked on JIRA for defect/issues logging & tracking and documented all my work using CONFLUENCE

Environment: Informatica Power Canter 10.4.0/9.5.1/9.6.1 , Talend 6.5.1, Oracle 11g/12c, Hive, AWS (RDS,Hive,Glue,Ec2,S3) Redshift, TOAD 10.1/12, DBeaver 3.8.2, PL/SQL, Unix, WinScp

Confidential

Responsibilities:

  • Worked in Agile Environment.
  • Good experience in Informatica Power Center and Informatica Data Transformation Studio.
  • Experienced in using Autosys job scheduling tool
  • Worked with product Owner, Business Analysts and Team Lead for requirements gathering.
  • Involved in review of the mappings and enhancements for better optimization of the Informaticamappings, sessions and workflows.
  • Working with XML source Files, UDT transformations and XML Schema Definitions (XSD).
  • Created batch scripts to automate the activities like start, stop, and abort the Informaticaworkflows by using PMCMD command in it.
  • Profoundly worked analysing and fixing the code defects raised from SIT/UAT resources.
  • Extracted data from different sources like Oracle and Flat files and loaded the data into DWH.
  • Developed mapping parameters and variables to support SQL override
  • Excellent experience in designing, modelling, performance tuning and analysis, implementing processes usingETLtoolInformaticaPower enter for Data Extraction, Transformation and Loading processes

Environment: Informatica Power Center 9.6.1, Informatica B2B Studio, Informatica Data Transformation Studio, Oracle 11g, PL/SQL, Toad 12, Autosys, ERWIN, UNIX, XML, Microsoft Office (Word, Excel, Access), HTML.

Confidential

Responsibilities:

  • Worked in Agile Environment.
  • Experienced in using the informtica debugger to test the data flow and fix the mappings
  • Experienced in using Autosys job scheduling tool
  • Developed Mapping and Session based on user requirements and business rules to load data from source tables to target tables based on the design document.
  • Performed Code reviews and Internal Quality checks on mappings created by the team
  • Performed Unit testing and creating unit test cases for different Subject Areas.
  • Closely worked with the database developer to ensure the database changes are implemented as per the requirement.
  • Tuning the complex mappings based on source, target and mapping, session level
  • Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate these activities.

Environment: Informatica Power Canter 9.5.1 (Power Canter Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica B2B Studio, Informatica Data Transformation Studio), Oracle 10g/11g, SQL, Autosys, Toad 12, UNIX, XML, MS Visio, Microsoft Office (Word, Excel, Access), HTML.

We'd love your feedback!