SUMMARY

• Having 13+ years of experience in full life cycle of Software Development (SDLC) including Business Requirement Gathering & Analysis, System study, Application Design, Development, testing, Implementation, System Maintenance, Support and Documentation.
• Experience includes thorough domain knowledge of Health Insurance & Telecom Industry.
• Being ETL lead, for highly adaptive to a team environment and proven ability to work in a fast paced teaming environment.
• Experience and Expertise in ETL process Informatica Power Center 9.x/8.x/7.x & Talend Open Studio 3.1/4.1, Talend Enterprise Big Data Edition 6.1, 7.1, 7.2 .
• Experience and Expertise in Informatica developer tool B2B .
• Experience and Expertise in Autosys scheduling tool.
• Expertise in NDM (Network Data Mover) File transfer between Clients Server with Data security and encryption.
• Experience and Expertise in Informatica PowerCenter Mappings, Mapplets, Transformations, Workflow Manager and Workflow Monitor. Also, Experience in Extraction / Transformation / Loading of legacy data to Data Warehouse.
• Experience and Expertise in Designed and developed data quality rules to evaluate and verify data transformations, Data Cleansing, Data Matching and error handling.
• Used different types of transformations including Address Validator (AddressDoctor), Labeler, Case Converter, Merge and consolidation Transformations in IDQ.
• Experience and Expertise in Talend ETL tool Tmap, Normalizer, Aggregator, filter, Lookup, Iteration and Unique and joiner transformation used.
• Experienced in Data Ingestion projects to inject data into Data lake using multiple sources system using Talend Bigdata.
• Expertise Talend Big data components like tHDFSInput, tHDFSOutput, tPigLoad, tPigFilterRow, tPigFilterColumn, tPigStoreResult, tHiveLoad, tHiveInput, tHbaseInput, tHbaseOutput, tKafkaInput and tKafkaOutput.
• Good experience in Big Data and Hadoop Ecosystem components like, Pig, Hive, Sqoop, Flume, MapReduce.
• Extensively worked on Databases like Oracle 11g/10g/9i/8i, SQL Scripting.
• Testing skills include performing Unit, Integration, and Volume testing as well as Development, Execution, and Maintenance of Test plans, Test specifications and Test scenarios.
• Good exposure with Change management processes.
• Good understanding of Data warehousing, ER Modeling and Dimensional Modeling concepts.
• Worked on preparing Low level, High level design documents along with Release notes & Run book and experience in coordinating offshore teams and delivering the results to clients.

TECHNICAL SKILLS

O/S: Windows NT/XP/98/2000, Unix, Linux

ETL Tools: Informatica PowerCenter 10.1.2/9.6.1/8.6/7.1.1 , Talend Open Studio 3.1/4.1

Database, Languages & Tools: Oracle 12c/11g,10g/9i/8i, MySql, Pl/Sql, MS - Access, Unix Shell Scripting, Autosys & Facets Trizetto

Tools: and Utilities: Toad, Sql Developer, Putty, HP Quality Center ALM, SBM (Serena Business Management).

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Developer

Responsibilities:

• Understanding the Business Requirements. Discuss with Client and Business team for any clarifications.
• Have done Design for ETL components and developed Hive objects.
• Created System Design Specification document for the complete process and Review with Client to get approval.
• Designed and developed the Talend Jobs, Joblets to load multiples Source Data into HDFS Data Lake.
• Developed complex Jobs with XML’s as source, target and Source Messages over MQ queues.
• Designed and developed data quality rules to evaluate and verify data transformations, Data Cleansing, Data Matching and error handling.
• Analyzed and identified performance bottlenecks and have done performance tuning.
• Performed Unit testing for the code and produced the Unit test case document.

Environment: Talend Enterprise Big Data Edition 6.1, 7.1, 7.2, UNIX & Oracle 12c, Auotsys, Kafaka,Hbase, HIVE, NDM, HP Quality Center ALM & Github (udeploy).

Confidential

Senior Informatica Lead

Responsibilities:

• Understanding the Business Requirements. Discuss with Client and Business team for any clarifications.
• Have done Design for ETL components and developed database objects.
• Created System Design Specification document for the complete process and Review with Client to get approval.
• Designed and developed the Informatica mappings, workflow and tasks to load multiples Source Data into different tables in Data Store, Extract Files.
• Developed complex mappings with XML’s as source, target and Messages over MQ queues.
• Designed and developed data quality rules to evaluate and verify data transformations, Data Cleansing, Data Matching and error handling.
• Analyzed and identified performance bottlenecks using session logs stats and have done performance tuning using Informatica partitions, lookups to handle huge data volume.
• Developed shell scripts to run Informatica job for each XML file using PMCMD command and if any error occurs while processing each XML, error details are send to given Email ID’s and continue to process the next XML file.
• Developed and tested Oracle PL/SQL Procedures, Functions, Triggers and Packages.
• Performed Unit testing for the code and produced the Unit test case document.
• Provide Support to SIT and UAT Testing. Fix the SIT Defects and Manage the Defects in HP ALM. Participate in DRB Calls to provide the Defects status updates.
• Deploying the Code to Higher Environments and Scheduling the Jobs through Autosys.
• Analyze the data, Generate the ad-hoc reports as per business team requests.
• Creating Unix script for NDM and SFTP for using file transfer.

Environment: Informatica Power Center 9.6.1, UNIX & Oracle 12c, Auotsys, SBM tool, NDM, HP Quality Center ALM & Github (udeploy).

Confidential

Senior Informatica Lead

Responsibilities:

• Leading as an onsite/offshore coordinator and lead team by providing ETL Technical/Functional documents and acted as a Point of Contact (POC) for the offshore team.
• Played a lead role in the requirement gathering, preparation of Engineering Requirement Specification document.
• Involved in System analysis, Estimations and design for enhancements.
• Troubleshooting and fine tuning of mappings for maximum.
• As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions and done code migration from one environment to other.
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation,Router Transformation, SQL transformation and Normalizer Transformation in Informatica.
• Source System Analysis and identify data anomalies, data cleansing opportunities (like identifying special character etc.)
• Used IDQ’s standardized plans for addresses and names clean ups.
• Involved in migration of the maps from IDQ to power center.
• Email notification and reports send to Business users using Command task.
• Created and Configured Sessions, Worklets and Workflows to load the data into target/s using Informatica Workflow Manager.
• Facets Trizetto Health care Application batch Interface for the entire project.
• Interacted with SBM (Serena Business Manager) process team and INFA ADMIN to migrate the code from one environment to other.
• Interacted with SBM (Serena Business Manager) process team and DBA to migrate the code one environment to other.
• Maintain in Informatica code versioning using Tortoise SVN tool.
• Responsible for Unit & Integration test environments and for data accuracy with consistency throughout its lifecycle.
• Testing team will raise Defect through HP Quality Center tool and this tool used for defect tracking.

Environment: Informatica Power Center 9.6.1, Informatica Developer IDQ 9.6.1, UNIX & Oracle 10g SBM tool, HP Quality Center ALM, Facets Trizetto & Tortoise SVN.

Confidential

ETL Lead / Developer

Responsibilities:

• Played a lead role in the requirement gathering, preparation of Engineering Requirement Specification document.
• Involved in System analysis, Estimations and design for enhancements.
• Analyzing the bugs and documenting the bug details in Quality Center tool and resolving them.
• Troubleshooting and fine tuning of mappings for maximum.
• As part of optimization and reviewable process, performed design changes and changes in Informatica mappings, transformations, sessions.
• The code migration from one environment to other using SBM tool.
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, Router Transformation and Normalizer Transformation in Informatica.
• Interacted DBA team to make sure application data base and also created all necessary data base objects for our project in Dev and Test Environments.
• Extracted data from multiple fixed width files using Informatica ETL mappings with indirect loading and loaded to target systems.
• Created Mapplets and Reusable Transformations to prevent redundancy of transformation usage.
• Responsible for Unit & Integration test environments and for data accuracy with consistency throughout its lifecycle.

Environment: Informatica Power Center 9.5, UNIX & Oracle 10g SBM tool, HP Quality Center ALM,