SUMMARY

• Over 10 years of experience in designing, developing, testing, and supporting data warehousing and ETL solutions using Informatica Power Center 8.x/9.x/10.x, IICS, and Snowflake for various industries including Health Care, Insurance, Banking, Telecom, Commercial, and Financial Services.
• Strong skills in data mapping for Slowly Changing Dimensions (SCD1, SCD2, and SCD3) and implementing complex business rules using reusable transformations and Mappings/Mapplets.
• Expertise in debugging and performance tuning of targets, sources, mappings, and sessions.
• Extensive experience in implementing data warehouses and data marts and estimating the level of effort required for implementation and integration testing.
• Proficient in all phases of software development life cycle (SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, and Post-Implementation.
• Skilled in designing logical and physical data models, creating mappings, mapplets, and reusable transformations using Informatica.
• Experienced in analyzing business requirements and translating them into functional and technical design specifications.
• Developed different types of SCDs effectively based on specifications and worked with different data sources such as Flat Files, XML files, and databases.
• Strong knowledge of cloud-based data integration and ETL processes, with extensive experience in building integrations between cloud-based applications and on-premises systems using IICS.
• Experience in designing, developing, testing, and deploying IICS workflows for various use cases such as data migration, data synchronization, and data replication.
• Proficient in using various IICS components such as Cloud Application Integration (CAI), Cloud Data Integration (CDI), and Cloud B2B Gateway for building complex data integration solutions.
• Expertise in building data integration solutions using various IICS connectors such as Salesforce, NetSuite, Workday, and ServiceNow.
• Hands-on experience in writing, testing, and implementing triggers, stored procedures, functions, and packages at the database and form level using SQL and PL/SQL, and tuning SQL queries for better performance.
• Successful at transforming business ideas and processes into complete solutions and configuring applications to fit the company's business model.
• Coordinated with offshore development teams to fix release issues and prepared project plans in collaboration with the project manager and development team.
• Excellent aptitude to understand and meet client needs, ability to easily grasp new concepts, and successful at working in a team as well as independently.
• Excellent interpersonal, communication, and presentation skills with the ability to interact successfully with team members and business customers.
• Provided technical leadership and guidance to team members, including mentoring and training on Informatica tools and best practices.
• Stayed current with insurance industry trends and regulations, including GDPR and other privacy regulations, and ensured that Informatica solutions remained compliant with relevant standards and requirements.
• Provided L1, L2, L3, support to various application.
• Conducted performance tuning and optimization of ETL processes using Informatica PowerCenter, resulting in significant improvements in data processing times and reduced resource utilization.

TECHNICAL SKILLS

Programming: UNIX Shell Scripting and PL/SQL, Python

ETL Tools: Informatica Power Center, Informatica Power Exchange, Informatica Data Quality, IICS, IBM Datastage

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Operating Systems: Windows 7/XP/NT/2000, UNIX

Databases: Oracle, IBM DB2, Teradata, SQL Server, SnowFlake

Other Technologies and Concepts: MS word, MS Excel, MS Power Point, Control-M, Numpy, Pandas, JSON, REST Web services, XML, Amazon Redshift, Amazon Web Services, Jira. GIT

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

Sr. ETL Developer

Responsibilities:

• Participated in the entire ETL process, including development, testing, and production support.
• Implemented Informatica Cloud Data Integration (IICS) to extract, transform, and load data from cloud-based insurance applications, such as policy administration systems and claims management systems.
• Designed and developed mappings and workflows in IICS to load and transform policy data, including policyholder information, coverage details, premiums, and claims data, into a centralized data repository.
• Worked with business users to define data requirements, design data models, and develop data integration solutions to support insurance analytics initiatives, such as claims analysis, risk modeling, and customer segmentation.
• Contributed to data analysis and requirement gathering efforts.
• Assisted in establishing standards and maintaining the data warehouse.
• Developed standard templates and patterns to streamline processes.
• Implemented a standard code migration process.
• Conducted detailed analysis of existing and new report requirements and prepared justification reports.
• Improved performance by identifying bottlenecks and optimizing sessions containing Rank, Lookup, Joiner, Sorter, and Aggregator transformations and partitioning.
• Resolved high-priority tickets, including priority 1 and priority 2 issues.
• Developed and maintained the data warehouse for reporting and operational consolidation.
• Utilized mapping parameters, mapping variables, and parameter files extensively.
• Designed data loading using indicator files and resolved loading failure cases, including database problems.
• Created technical design documents, production support documents, and deployment documents.
• Utilized GIT for code migration.
• Extracted data from various interfaces, including relational databases, flat files, and XML.
• Developed high-quality slowly changing dimension (SCD) packages and procedures.
• Used SQL Server Profiler to create traces and optimize long-running queries as part of performance tuning operations.

Environment: Informatica Power Centre, TriZetto Facets®, GIT, CA Workstation, Oracle 11g/12c, Toad 10, UNIX, Jira.

Confidential, NewYork, NY

Data Engineer

Responsibilities:

• Developed ETL (Extract, Transform, Load) workflows in Informatica PowerCenter to facilitate the transfer of healthcare data between disparate systems, including Electronic Health Record (EHR) and Practice Management (PM) systems.
• Designed and implemented data integration solutions using Informatica Intelligent Cloud Services (IICS) to enable the seamless exchange of data between on-premises and cloud-based healthcare applications.
• Created mappings and workflows in IICS to load and transform patient data from various sources, including claims data, laboratory results, and clinical notes, into a centralized data repository for analysis.
• Collaborated with cross-functional teams to define data requirements and develop data models for healthcare analytics initiatives, leveraging Informatica's suite of data management tools.
• Implemented data quality rules and automated data profiling using Informatica Data Quality (IDQ) to ensure the accuracy and completeness of healthcare data.
• Conducted performance tuning and optimization of ETL processes using Informatica PowerCenter, resulting in significant improvements in data processing times and reduced resource utilization.
• Created complex mappings that involved slowly changing dimensions, implementation of business logic, and capturing deleted records in the source systems and reusable mappings for processing different transactional source system's data, which reduced development effort.
• Created UNIX scripts for archiving source, target, and bad files and effectively made use of Informatica deployment groups for code migration between the environments, target load order, and constraint-based loading techniques.
• Designed complex source qualifier queries and parameterized them for reusable purposes.
• Designed and implemented data privacy and security measures using Informatica's data masking and encryption capabilities to protect sensitive patient information.
• Conducted user training sessions to educate healthcare staff on the use of Informatica tools and data management best practices.
• Stayed current with healthcare industry trends and regulations, including HIPAA, and ensured that Informatica solutions remained compliant with relevant standards and requirements

Environment: IICS, Informatica Power Center 9.X/10.X, Snowflake, Oracle 11g/12c, SQL Server, Agile Process, UNIX, Python, Jira.

Confidential, Birmingham, Alabama

Sr. ETL Developer

Responsibilities:

• Study ELD (Enterprise Language for Data) relational data model and prepare source to target mapping sheets for different source application systems (Snowflake DWH, MDM, Salesforce, DB2).
• Published effective source to target mapping specification documents by conducting functional mapping sessions with source system owners.
• Developed and maintained data integration workflows using IICS to extract, transform, and load financial data from multiple sources, including core banking systems, transactional databases, and third-party data providers.
• Designed and implemented mappings and workflows in IICS to transform financial data, including customer information, account balances, transactional data, and investment data, into a centralized data repository.
• Collaborated with business stakeholders to define data requirements and develop data models to support banking analytics initiatives, such as fraud detection, risk management, and customer segmentation.
• Designed high level and low level ETL process flows.
• Analysed & prepared LOV (list of valid values) files for Master data load.
• Developed Datastage Jobs to load Collections data from multiple sources Aspect, CACS, Strata, FICO, Fidelity and FDR to the respective Dimensions and Fact tables with required business transformations.
• Implemented Informatica mappings using Informatica Bid Data Edition for capturing change data from legacy system (DB2).
• Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets.
• Created own SQL scripts to compare data between the legacy and converted data for all the business Scenarios.
• Prepared technical documentation, design transformations that are consistent with the goals of the existing data warehouse, and worked with the development team to implement the solution
• Worked in legacy code to analyze problems, confirm requirements, and create designs, code and testing.
• Experience in designing, developing, and testing Informatica extract/transform/load processes in a Data Warehouse.
• Extensively Used UNIX Commands like Sed, Awk, Grep commands for handling the files.
• Created scripts for all the Balance points while converting the data.
• Generated Gap reports after the reconciliation is completed for the gap analysis.
• Created column and table level profiling reports for data analysis by business users.
• Extensively worked on Performance Tuning of ETL Procedures and processes.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Created reusable mappings which can be used for processing different transactional source system’s data which directly reduces development effort.
• Create UNIX scripts for archiving source, target and bad files.
• Effectively make use of Informatica deployment groups for code migration between the environments.
• Effectively make use of target load order and constraint-based loading techniques.
• Designed complex source qualifier queries and parameterized them for reusable purpose.

Environment: IICS, Informatica Power Center 10.X, Informatica Data Quality 10.X, Informatica Power Exchange, Oracle 11g/12c, SQL Server, SysAdmiral, Toad 10, Visual Studio 2013, Agile Process, UNIX, Data flux, Amazon Web Services, Jira.

Confidential

Sr. ETL Developer

Responsibilities:

• Involved in ETL process from development to testing and production environments.
• Involved in Data Analysis, Requirement gathering.
• Involved in setting standards and Warehouse maintenance.
• Developed ETL scripts in Python to get data from one database table and insert, update the resultant data to another database table.
• Created standard templates or patterns to standardize the process.
• Established standard Code migration process.
• Performed detail analysis on existing and new reports requirements by understanding the justification report.
• Involved in Performance tuning by determining bottlenecks and increased better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations and involved in partitioning.
• Resolved priority 1, priority 2 level tickets.
• Involved in On-Call rotation process on a weekly basis.
• Involved in development and maintenance of the data warehouse for reporting and consolidations of the operations.
• Extensively used mapping parameters, mapping variables and parameter files.
• Designed load the data by starting the batches using indicator files.
• Troubleshoot the loading failure cases, including database problems.
• Prepared Documents like Technical Design Doc, Production Support Doc, and Deployment Document.
• Used Deployment groups for code migration.
• Obtained data from different interface like Relational databases, Flat files and XML.
• Scheduled the jobs using Tivoli Scheduling tool.
• Experience in kicking off the Informatica processes using UNIX scripts.
• Experience in developing high quality SCD packages and procedures.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.

Environment: Informatica Power Center, IICS, Snowflake, Oracle, MS SQL Server, MS Visual Studio, Tivoli Job Scheduler, Toad

Confidential

ETL Developer

Responsibilities:

• Involved in designing the Workflows, Worklets, Mappings, Sessions and configuring the Informatica Server using Informatica Power Center and scheduling the Workflows and sessions using scheduling tools.
• Involved in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures, Triggers, Funcation and packages to suit BOFA requirements.
• Involved in logical and physical database design.
• Error handling in ETL Process.
• Responsible for utilizing technological analysis and design principles to formulate detailed application plans and processes in order to implement clients' requests for new or modified functionalities.
• Designed and developed Oracle PL/SQL Procedures, wrote SQL, PL/SQL scripts, Functions and Package code for extracting data to system.
• Analyzed clients' requests for new or modified applications through interviews and design sessions.
• Implemented the integration and customization of customer-specific system packages.
• Involved in Planning and scheduling of the work among the resources.
• Liaison between the client team and the offshore team and ensure the common understanding on the requirements specified
• Used Explain Plan for monitoring query performance and for taking necessary action.
• Optimized SQL queries using hints and indexes.
• Performed scrubbing and cleaning of the data.
• Worked with offshore team and engaged in development and support activities.
• Transformed, versioned and summarized the data.
• Extensively involved in ETL code using Informatica Power Center in order to meet requirements for extract, transformation, cleansing, and loading of data from source to target data structures.
• Responsible for weekly status updates showing the progress of the ETL process.
• Documented Process Flow for mappings and sessions
• Created Run and wrapper Scripts to call set of Informatica workflows and shell scripts to insert the records in ETL control table.
• Involved impact analysis to upgrade Informatica Power Center 8.1 to Informatica Power Center 8.6
• Developed reusable transformations, Mapplets and Worklets to reduce development.