Data Integration Warehouse
Resume:
Ramya
Sr. ETL Informatica IICS Developer
************.*****@*****.*** Mobile:732-***-****
Professional Summary:
Around 12 years of IT experience with strong expertise in design development, testing and implementation of software applications in Data Warehousing and Client/Server environment.
Expertise in analysis, design, development, and testing of Data warehouse applications using Informatica PowerCenter10.1/9.6/9.1/8.6/ 8.1.1 A
Experience with a strong background in SDLC, Data integration tools including Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS) and business intelligence tools like power BI.
Experience working with Informatica IICS tool effectively using it for Data Integration and Data Migration from multiple source systems.
Experience working with IICS concepts relating to Data integration, Monitor, Administrator, deployments, permissions, schedules.
Understanding the business rules and sourcing the data from multiple source systems using IICS.
Experience in complete life cycle implementation of an Enterprise Data warehouse and Data mart.
Strong experience in designing the Documents for loading data into Datawarehouse and DataMart tables.
Proficient Knowledge in Power Center tools like Designer, Workflow Manager and Workflow Monitor.
Expertise in implementing complex Business rules by creating robust Mappings/Mapplets, reusable Transformations and Tasks.
Experience on Development, Integration, Migration and Production support applications which includes Insurance, Health care and financial domains.
Experience in Healthcare Business, Agile delivery model and Scrum methodologies.
Experience in creating Complex Workflows and Worklets using Informatica10.1/9.6/9.1/8.6/ 8.1.1
Extensively worked with different Data sources ranging from Flat files, Oracle, SQL server.
Experience with SQL Developer as an interface to databases, to analyze, view and alter data. Implemented Slowly Changing Dimensions Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information.
Experience in working with multiple RDBMS including Oracle 12.8/10g/9i/ 8i, SQL Server, and MS Access.
Strong expertise on various data design models like Star Schema and Snowflake models.
Extensive experience in Unix and shell scripting
Exceptional analytical and problem-solving skills.
Team Player with the ability to communicate effectively at all levels of the development process
Flexible and Versatile who can adapt to any new environment and learn fast with excellent communication & interpersonal skills.
Educational Qualification:
MCA from Visveswaraya Technological University (VTU), Belgaum – India – 2010
B.SC from Acharya Nagarjuna University (ANU), Andhra- India - 2007
Technical Skills
Operating Systems
Windows 2008/XP, Unix, Linux
ETL Tools
Informatica 10.1/9.6/9.1/8.6/ 8.1.1
Packages
SQL* PLUS, Toad 7.x
Applications
MS Word, Excel and PowerPoint.
Web technologies
HTML, DHTML, JSON
Data Bases
Oracle 9i/10g, MS SQL Server,DB2
Languages
SQL, Pl/SQL, Unix Shell Scripting
Other Tools
GIT, Jenkins, Udeploy, Golden Source, EDX (Enterprise Data exchange)
Professional Experience
Client : Bank of America, New Jersey
From : July 2023 – Till Date
Role : Sr. ETL Informatica Developer
Description: Played a key role in the development and enhancement of various data applications. Designed and developed advanced ETL processes using Informatica power center, improving data processing speed by 25% . Identified, analyzed and interpreted trends or patterns in complex data sets.
Improved data consistency, quality and efficiency, reducing load.
Responsibilities:
Analyzed the requirements to identify the necessary tables that needs to be populated into the staging database. Created Informatica workflows by creating mappings, mapplets, sessions, and workflows Working with different ETL transformations including Aggregator, Expression, Filter, Router, Sequence generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter.
Converted existing PL/SQL packages to ETL mappings using Informatica Power Centre.
Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
Implemented parallelism in loads by partitioning workflows using Pipeline, Round-robin, Hash, Key Range and Pass-through partitions.
Extensively involved in performance tuning, recommended SQL queries for better performance.
Performed audit on ETL’s and validated source data Vs target table loads.
Identity and analyzed data discrepancies and data quality issues and work to ensure data consistency and integrity.
Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems from Oracle, Flat files to load into Staging, Data warehouse.
Responsibilities worked with Business Analyst to understand business/system requirements in order to transform business requirements into effective Technology solutions by creating Technical specifications for the ETL from the Functional specifications.
Arranged weekly meetings with the offshore team and discuss both the technical and non-technical issues along with the status of work from time to time.
Estimated the efforts based on the tasks assigned to team and guide them accordingly.
Purged a part of the existing code that is not required anymore and enhanced where needed.
Used Informatica Cloud to extract the data from Salesforce to Oracle database.
Developed code to load the data from Flat file to stage and stage to DWH.
Monitoring the jobs, observing the performance of the individual transformations and tuning the code(Performance Tuning). Migrating objects between different Environments using XML Export/Import (using Repository Manager).
Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
Development of ETL Informatica applications and Metadata management.
Client : AIG, New Jersey
From : Feb 2022 – Till Date
Role : Sr. ETL Informatica Developer
Description: Enterprise Data Integration (EDI) is to integrate or migrate all subjects’ areas into one system.
Responsibilities:
Analyzed the functional specs provided by the client and created technical specs documents for all the mappings.
Design and built IICS mappings to extract data from SFDC, Oracle, SQL Server and loaded in to the designed the ETL flows for generating flat file extracts as per the business need.
Worked on converting Informatica Power center ETL code to IICS using PC to Cloud Conversion service.
Involved in enhancements and maintenance activities of the Data warehouse.
Designed Mappings, Integration Templates, Bundles and Task flows.
Developed and tested Informatica mappings based on the specification.
Provide support for deployment activities and production support activities.
Worked closely with DBAs, admins, ETL developers and change control management team for migrating developed mappings across Dev, QA and Prod environments.
Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
Used windows Scripting and Scheduled pm CMD to interact with Informatica Server from command mode.
Handling changes requests to change the mappings and strategy to include changes in business rules.
Experience in performance tuning and query optimization.
Experience in Healthcare Business, Agile delivery model and Scrum methodologies.
Knowledge of Data Warehouse concept, ETL concepts and tools preferred.
Demonstrated results and competence developing ETL process using Informatica Power Center.
Performed analysis of Business and system requirements including Impact analysis of existing systems and create design specifications with the consultation of Business users and technical architects. Provides support during the system implementation.
May work with business operations to capture metadata to build out data models.
Work with project teams to plan and execute the quality control process.
Strong experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor and Repository Manager.
Develop ETL data workflows and code for new data integrations and maintain/enhance existing workflow and code.
Experience in using complex transformations.
Experience in error/exception handling using Informatica mapping.
Proficient in performance tuning and usage of partitions.
Preferable experience using Informatica IDQ.
Involved in Design Review and preparation of ETL Unit test code review Design Documents.
Used capture issues using Issue Tracker and did log error Quality Center Testing tool.
Responsible for Performance Tuning at the Source & Target level, Mapping Level and Session
Level.
Did involve in both Development and testing phases of the project following Agile methodologies.
Migrated repository objects, services, and scripts from development environment to production environment Involved in Informatica Baseline Testing 9. 1version.Did Baseline Testing and as well as regression Testing
Project management activities such as status tracking and coordinating client calls.
Support for all the security master central applications and provide solutions to production failure jobs.
Environment: INFORMATICA 10.1, SQL, Agile, Oracle 12c, IICS / INFORMATICA Power Center 10.2/IICS/Oracle/ SQL Server/ Agile
Client : DXC Malaysia
From : Sep 2019 – Jan 2022
Role : Sr. ETL Informatica Developer
Description: The Malaysia scrum project is aimed at developing the process in HP People Hub (Payroll HUB or ADP HUB) responsible for loading data out of the Workday source system and generating daily Global View gateway file (G2 file) to be sent to ADP Global View (ADPGV) for loading.
Responsibilities:
Human Resources (HR) team enters new hired employee information into Workday or employees update their employee information in Workday.
Workday executes Payroll Integration Run based on Integration schedule.
Payroll Integration Run identifies and extracts all data changes based on country paygroup, pay period and data entry date.
I was involved in the regular maintenance of the Data mart monitoring the data loads regularly and addressing any disruptions in their daily run.
Addressing Informatica load failures identifying the issue and executing auxiliary loads to load the missed data into the Data warehouse.
Handling changes requests to change the mappings and strategy to include the changes in business rules.
Co-coordinating with the source teams to ensure timely transfer of source files and intimating then in case of any delays.
Optimizing/Tuning mappings for better performance and efficiency.
Attending the Weekly status calls with client explain the weekly status of the loads and any issues.
Responsible for Performance Tuning at the Source & Target level, Mapping Level and Session
Level.
Involved in Design Review and preparation of ETL/Reporting Design Documents.
Involved in production support for the data warehouse informatica jobs.
Testing - unit testing, integration testing & performance testing.
Use Informatica PowerCenter to Extract, Transform, and Load (ETL) source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files and the addition to the EDW of any new fields requested via the change request process
Automate the staging of data by scheduling scripts to run at optimal times enhancing overall system performance and efficiency
Create, maintain, and support an ETL/Informatica architectural and system environment for development and production
Implementing ETL jobs by creating mappings, mapplets, sessions, and workflows Working with different ETL transformations including Aggregator, Expression, Filter, Router, Sequence
Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter
Scheduling and monitoring ETL/Informatica jobs in a development, system testing, and production environment
Developing proactive processes for monitoring capacity and performance tuning
Supporting and advising the development teams on technical issues Data quality implementation Informatica Developer (IDQ)
Environment: INFORMATICA 9.1, SQL and Oracle 12c
Client : AIA Malaysia
From : Feb 2018 – Aug 2019
Role : Sr. ETL Informatica Developer
Description: The Malaysia scrum project is aimed at developing new APIs as well as enhancements on the existing ones based on requirements received from user and business. As part of the informatica team our responsibility is to create the mappings and load the data coming from source systems into the database and develop API queries which in turn will be called by the web methods in order to retrieve the data.
Responsibilities:
My responsibility as a developer is to develop the changes, we get through user stories as we operate as scrum teams which is an AGILE platform and providing daily stand up to scrum master as on daily basis.
Done the impact assessment in terms of schedule changes, dependency impact, code changes for various change requests on the existing Data Warehouse applications that running in a production environment.
Proactively involved in production Batch Support.
Provided quick production fixes and proactively involved in fixing production support issues.
Have strong knowledge in data mover for importing and exporting of data.
Used Data Mover to copy data and objects such as tables and statistics from one system to another.
Analyze business requirements, designs and write technical specifications to design and redesign solutions
Involved in complete software development life-cycle (SDLC) including requirements gathering, analysis, design, development, testing, implementation and deployment.
Coordinate with Configuration management team in code deployments.
Mostly I will be involved in AGILE meetings also to come over a plan on design and development of the API’s as how they can be achieved and delivering it to customers/PO’s onsite and other heads and panning for the GO live by having regular communication with support teams.
Also my duty has a developer is to commit the work done by us in SVN and helping the Infra team for the deployment starting from Lower to Higher environments.
When any issue or defects are raised by the support team it’s our responsibility to debug and provide the solution by fixing it with necessary documentation and uploading them.
As a developer I will also be helping the other team members with the approach of the design and how it can be achieved in the existing API’s as most of the developments here are on existing API’s.
Environment: INFORMATICA 10.1, Oracle and SQL
Client : John Hancock, India
From : March 2012 – Jan 2018
Role : Informatica Developer
Description: The Life Admin System Consolidation project aims at converging 13 different policy admin systems into a single platform. In Phase 1 of this project 2 of these 13 admin systems are being converted to Wealth Management Accelerator (WMA). Going forward the WMA will be source for all the admin systems. However, JHIM LASC counterpart is only responsible for building the ETL routines for these policies once they are sourced from WMA to create the daily extracts or reports for downstream applications. Also, the data received from WMA should update the ODS and MDM systems with daily changes.
Responsibilities
I was involved in the regular maintenance of the Data mart monitoring the data loads regularly and addressing any disruptions in their daily run.
Addressing Informatica load failures identifying the issue and executing auxiliary loads to load the missed data into the Data warehouse.
Handling changes requests to change the mappings and strategy to include changes in business rules.
Co-coordinating with the source teams to ensure timely transfer of source files and intimating them in case of any delays.
Optimizing/Tuning mappings for better performance and efficiency.
Attending the Weekly status calls with client explain the weekly status of the loads and any issues.
Responsible for Performance Tuning at the Source & Target level, Mapping Level and Session
Level.
Involved in Design Review and preparation of ETL/Reporting Design Documents.
Worked on Creation of mappings using Informatica8.6 and Performance tuning of backend SQL generated for BO reports for faster Report Output.
Developed SQL packages for analyzing the source system data and for generating the extract scripts for loading data into staging tables.
Involved in production support for the data warehouse informatica jobs.
Testing - unit testing, integration testing & performance testing.
Requirement analysis and communicating the gaps in the requirements to business.
Creating the high level and detail design for the modules.
Preparing unit test cases based on the requirements.
Building workflows for the project using Informatica PowerCenter 9.5.0, DB2 and UNIX Scripts.
Designing Workflows and their ESP Jobs for various processes included in the project.
Walkthroughs with the Analyst to ensure that the deliverables meet their objectives.
Tracking all the defects through ALM and taking the corrective measures for them.
Providing QA and UAT support.
Using CA Automation tool to schedule and monitor the jobs.
Taking care of non-technical deliverables like Project plan, Resource loading plan, daily dashboards, and weekly status reports.
Preparing Run manual and other support related documents for handover
Environment: INFORMATICA 9.1, SQL Server
Contact this candidate