SUMMARY

• 12 years of experience in the IT industry and wide range of progressive experience in providing product specifications, design, data analysis, development, documentation, coding, and implementation of BI solutions.
• Experience of working in Healthcare & Pharmaceutical domain, Insurance domain, public assistance and Eligibility systems for Various DHHS, Health data reporting and Health transfer & handling using standards massages queue ex - HL7.
• Experience of handling PII and PHI.
• Experience of driving end to end projects and handling customers.
• Experience and good understanding of Agile and Waterfall methodology.
• Extensive knowledge of ETL and Data warehousing concepts, have been working on Informatica Power Center 10.5, Informatica Intelligence Cloud Service, Snowflake and Oracle Data Integrator 12c.
• Working experience in Tableau.
• Working experience and knowledge of Unix scripting and SQL.
• Excellent knowledge in Unit, System, Regression, Integration, Smoke/Sanity, UAT testing methodologies.
• Extensive experience of working tools like SQL Developer, TOAD. Knowledge of databases primarily Oracle 9i/10g/11g, DB2.
• 3 years of experience in production support and ticket managing systems & reporting.
• Knowledge of masking the privacy data in non-production environments for legal compliance.
• Excellent analytical, problem solving, communication and interpersonal skills with ability to interact with individuals at all levels.
• Experience of managing multiple projects with changing priorities and tight deadlines.
• Experience of working onshore/offshore model and handled 15+ members team.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2, Oracle Data Integrator 12c, Informatica Intelligence Cloud Service

Visualization Tool: Tableau

Databases: Oracle 11g/10g/9i, Teradata, DB2, Snowflake

Programming: SQL, Unix

Scheduling Tools: CA Workload Automation Desktop Client, Control-M, ASG Zena automation

Reporting Tools: Basic of Business Objects and Tableau

PROFESSIONAL EXPERIENCE

Confidential

Data Integration Team Lead

Environment: Informatica on Cloud, Snowflake, SQL server.

Responsibilities:

• Working on designing, building and testing data pipelines.
• Identifying data leaks and fixing that to ensure data quality.
• Working in agile principles and delivering work on time with keeping quality first preference.
• Data profiling & Discovery for any new Integration.
• Assisting team and providing guidance in trouble shooting any failures, issues, or discrepancies.
• Working closely with business and IT stakeholders to support their end-to-end data needs.

Confidential

Data Integration Team Lead

Environment: Informatica 10.5, Informatica on Cloud,, Oracle, Linux, ASG Zena Automation, Agile

Responsibilities:

• Working on designing, building and testing data pipelines.
• Working on creating standard HL7 messages to transfer & share the medical information between health organization.
• Working in agile principles and delivering work on time with keeping quality first preference.
• Data profiling & Discovery for any new Integration.
• Assisting team and providing guidance in trouble shooting any failures, issues, or discrepancies.
• Working closely with business and IT stakeholders to support their end-to-end data needs.

Confidential

Senior Developer ETL/Data Migration Specialist

Environment: Informatica 10.2, Oracle, OpCons & Windows Batch (For Scheduling).

Responsibilities:

• Gathering requirements and analyzing raw data, data profiling and discovery.
• Design & development using Informatica Power Center and other required tools.
• System Integration testing and End-End Testing with downstream applications.
• Troubleshooting and resolving SAT and UAT bugs and issues.
• Implementation and production support.
• Co-coordinating with platform support teams, Up streams & downstream teams and business user & testers.

Confidential

Developer ETL/Production Support

Environment: Informatica 10.2, Oracle, Control M (For Scheduling).

Responsibilities:

• Gathering requirements and analyzing data.
• Computing complex calculation using ETL to maximum accuracy considering the decimal precision importance.
• Design and test plans creation and review.
• Development using Informatica Power Center and other required tools & technologies.
• System Integration testing and End-End Testing with downstream applications.
• Implementation and production support.
• Co-coordinating with platform support teams, Up streams & downstream teams and business user & testers.

Confidential

Lead ETL/Production Support

Environment: Informatica 9.1/8.6, DB2, Teradata Control M (For Scheduling).

Responsibilities:

• Job monitoring and production support.
• Enhancements: - Requirement gathering, LOEs, plan creation, development, and implementation.
• Co-ordination and helping business users for IT related queries.

Confidential

Lead ETL/Production Support (Business Objects, Teradata)

Environment: Informatica 9.1/8.6, Teradata, Business Objects, UNIX and SQL, WLM/Control M Tools (For Scheduling.

Responsibilities:

• Job monitoring and production support.
• Enhancements: - Requirement gathering, LOEs, plan creation, development and implementation.
• Co-ordination and helping business users for IT related queries.
• Co-ordination with offshore and business users.
• Design, Develop and deploy jobs in WLM/Control M schedules.
• Monitor and troubleshooting of jobs/schedules and take appropriate remedy steps.
• Troubleshooting and managing high severity ServiceNow incidents.

Confidential

Lead ETL/Informatica Developer

Environment: Informatica 9.1/8.6, Oracle 10g/11g TOAD, UNIX and SQL, Workload Automation Tool (For Scheduling.

Responsibilities:

• Gathering requirements and analyzing raw data.
• Design and test plans creation and review.
• Development using Informatica Power Center and other required tools & technologies.
• System Integration testing and End-End Testing with downstream applications.
• Implementation and production support.
• Co-coordinating with platform support teams, Up streams & downstream teams and business user & testers.
• Design, Develop and deploy jobs in CA workload automation to support smooth execution of batch script, shell script jobs.
• Monitor and troubleshooting of CA jobs/schedules and take appropriate remedy steps.
• Troubleshooting and managing high severity ServiceNow incidents.