Etl Informatica Developer Resume
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.