Resume

Sign in

Informatica etl Developer

Location:
Herndon, VA
Salary:
$95000
Posted:
October 12, 2021

Contact this candidate

Resume:

DIVYA SRI

ado0kx@r.postjobfree.com/571-***-****

SUMMARY

Six years of experience in ETL/Informatica, four plus years in data warehousing and data integration in all phases of the SDLC (Software Development Life Cycle) including analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines

Proficient with Informatica Power Center designer tools (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer), Workflow Manager Tools (Task Developer, Worklet and Workflow Designer)

Experience with RDBMS including Oracle 10g/9i, Oracle 12c, SQL Server and My SQL

Experience with dimensional modeling using star schema and snowflake models

Created UNIX shell scripts to run Informatica workflows and control the ETL flow

Skilled in the development of Informatica mappings and mapplets and tuning them for optimum performance

Experience working in an Agile development environment

Hands on experience with tools like Toad and SQL Developer

Well acquainted with session partitioning and performance tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings

Proficient in creating stored procedures, tables, cursors, views, indexes, SQL joins and performance based query writing

Used advanced PL/SQL concepts for implementing complex ETL logic

Strong knowledge of slowly changing dimensions

Migrated objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production

EDUCATION

Bachelors in Electronics and Communication Engineering, JNTU, India.

SKILLS

Informatica

Informatica Power Center 10.x/9.x, Power Mart5.1.1/5.x, Oracle Warehouse Builder 11gR2, Oracle Data Integrator 10.1/11.1,Warehouse Designer, Power Connect, Power Exchange, Informatica Developer IDQ,Informatica Designer, Workflow Manager, Workflow Monitor, OLAP, OLTP, Flat Files, RDBMS tables, legacy system files

Data Modeling

Dimensional Data Modeling, Erwin 7.1, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical/Logical data modeling and Oracle Designer

Methodologies

Ralph Kimball, ODS, EDW and Metadata repository

Databases

Oracle 12g/11g/10g, DB2 8.0/7.0, MS SQL Server, Netezza, Teradata, Sybase 12.x

Dimensional Data Modeling

Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer

Programming GUI

SQL, PL/SQL, SQL*Plus, SQL*Loader, Transact SQL, ANSI SQL, Synopsis, Visual Basic .Net/6.0/5.0, Java, HTML, DHTML, C, C++, UNIX Shell Scripting, PERL Programming

Other tools

Tidal Scheduler, Autosys, Tibco

EXPERIENCE

JUN 19’ – Current ETL/Informatica Developer Highmark Inc, Pittsburgh, PA

Highmark Inc. is a national, diversified health care partner serving members through its businesses in health insurance, dental insurance, and reinsurance.

Brief: ODH(Operational Data Hub) is repository for member, provider, claims & pharmacy information. The primary objective of the project was to build the data warehouse system integrating insured member/agent policy and claims information to satisfy the company’s need for fast financial report generation. The immediate objective was to develop a Data Mart to handle health insurance member, their policy need and claim Extracted data from fragmented data sources across the company was transformed and loaded into target Data Marts

Interacted with business analysts to finalize the requirements and completed the technical design document for coding

Managed the design, development and implementation of the ODH decommissioning project using Informatica Power Center, reducing development and implementation cost

Successfully managed and implemented various ETL projects using Informatica Power Center that loaded data from DB2, flat files and other data sources to Oracle and other targets used for reporting

Created mappings for both full and delta loads

Designed and developed parallel jobs, sequences using Designer

Designed POC mappings and helped the ETL team with data acquisition techniques and loading strategies during the development phase

Documented the expected level of effort and resource requirements to configure required ODH processes to support the client on boarding and maintenance business processes

Defined and designed the Data Acquisition, Transformation, and Data Cleansing approach for the ODH implementation

Worked on the 10 ODH releases, implemented the business requirements for Claims, Member, and Provider data in Oracle data warehouse

Designed several parallel jobs using Sequential File, Dataset, Join, Merge, Lookup, Change Apply, Change Capture, Remove duplicates, Funnel, Filter, Copy, Column Generator, Peek, Modify, Compare, Oracle Enterprise, Surrogate Key, Aggregator, Transformer, Row Generator stages

Worked with SCD stage for implementing slowly changing dimensions. Extracted data from Flat Files and Oracle databases and applied business logic to load them in the central Oracle database

Developed map, reusable objects, transformation, and Mapplets using Mapping Designer, Transformation Developer and Mapplets Designer

Created reusable transformations and mapplets and used them in mappings

Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse

Worked with data modelers to prepare logical and physical data models and added and deleted necessary fields using Erwin

Tidal Scheduler was implemented for scheduling of Informatica workflows

Interacted with the vendor and set up the SFTP connection to the vendor’s ftp site for transferring extracted files

Set up SFTP connections to various vendors for receiving and sending of encrypted data as part of MFT Integration team support

Implementations were populated slowly to change dimension to maintain current information and history information in dimension tables

Used Informatica PowerCenter Workflow manager to create sessions and batches to run with logic embedded in the mappings

Created folders, users, repositories, and deployment group using Repository Manager

Created Shared Containers to increase Object Code Reusability and to increase throughput of the system

Used environment variables, stage variables and routines for developing parameter driven jobs and debugged them

Performed extraction, transformation and loading of data using different types of stages and by performing derivations over the links connecting these stages

Designed the job templates and created new jobs from existing templates

Enhanced job performance by using partitioning methods and analyzing the resources utilized using Job Monitor

Created test plans for unit testing of designed jobs

Environment: Informatica Power Center 10.2/10.1 (Repository Manger, Designer, Oracle Warehouse Builder 11gR2, Oracle Data Integrator 10.1/11.1, Workflow Monitor, Workflow Manager),Informatica Power Exchange for Oracle CDC, Informatica Developer IDQ, Tidal Scheduler, Autosys, DB2, Oracle 12g, Siebel, TOAD, SQL*Plus, Windows, UNIX, Shell Scripting

Jun 17-Mar 19 ETL/Informatica Developer Independent Health, Buffalo, NY

Independent Health provides health plan that continually aims to provide the community with innovative health-related products and services, which enable affordable access to quality health care and unmatched relationships with physicians and providers. We ensured the successful implementation of projects in support of corporate initiatives and performed detailed analysis, developed detailed designs, programs and tested applications.

Created high level design, technical design documents and mapping documents based on business requirements

Configured, designed and developed ETL for Enterprise Data Infrastructure (EDI) DataMart which includes sourcing, vending the security data

Optimized complex ETL processes using performance tuning methods

Created program to implement Change Data Capture CDC using Informatica to perform inserts, updates, and delete operations

Monitored and executed production jobs whenever required

Performed unit, system and integration testing to validate source and target data and performed internal quality auditing of the ETL code before delivery

Created Informatica tasks and workflows to execute ETL processes

Wrote complex SQL Query as per business requirement to fetch the data from relational tables

Optimized complex SQL query to improve performance

Created Slowly Changing Dimension SCD type1, type2, Slowly Growing Targets, and Simple Pass Through Informatica mappings to meet business requirements

Worked on XML source/target and used XML Source Qualifier, XML Parser and XML Generator transformation

Performed Unit testing, Integration testing/User Acceptance testing for ETL/SQL/Unix script codes

Developed UNIX shell scripts to run the workflows and SFTP source/target files from various systems and Informatica process automation

Executed Autosys command/box to run the Informatica workflows

Environment: Informatica Power Center 9.6 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Informatica Power Exchange for Oracle CDC, Informatica Developer IDQ,Autosys, DB2, Oracle12g, Netezza, TOAD, SQL*Plus, Tibco, Windows, UNIX, Shell Scripting

Jul 14 – Oct 16 ETL/Informatica Developer Intelligroup Asia Pvt. Ltd. Hyderabad, India

The objective of this project was to maintain & enhance databases for the Credit card and Merchant Resolutions department. The enhancement was planned by importing a few tables from different databases (Finance & Sales), modifying the existing table structure, creating necessary views and temporary tables and loading data in the database.

Environment: Informatica Power Center 9.1, Oracle Warehouse Builder 11gR2, Oracle Data Integrator 10.1/11.1,s Informatica Developer IDQ, Oracle 11g/9i, SQL, PL/SQL.



Contact this candidate