ETL/Informatica Developer
Resume:
Yatish
ETL/Informatica Developer
Email ID: ***********@*****.*** Ph:614-***-****
Professional Summary
Over 8 years of experience in Informatica Core Development, Testing and Production support and Informatica Power Center administration activities.
Strong working experience in Informatica Power Center Data Integration Tools-Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.
Has worked for domains like Insurance, Manufacturing and Healthcare.
Expertise in working with relational databases such as Oracle 11g/10g, SQL Server 2008/2005, DB2 and Teradata.
Expertise in Data Warehouse/Data mart, File feeds, ODS, OLTP and OLAP implementations teamed with project scope, data modeling, ETL development, System testing, Implementation and production support.
Hands on experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, Oracle SQL and Oracle PL/SQL.
Experience in Star schema, Snowflake schema methodologies.
Extracted data from various source systems like Oracle and flat files as per the Business requirements.
Performed Data profiling and Data analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
Performed various source system analysis for data compatibility between systems and perform ETL data loads.
Used PowerCenter Data Virtualization to define, modify, and enables reuse of data integration procedures by storing and managing data models, transformations, workflows.
Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g, MS SQL Server, DB2 and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
Experience in using Automation Scheduling tools like Autosys and Control-M.
Applied the concept of Change Data Capture (CDC) and imported the source from Legacy systems like Mainframe, Cobol using Informatica Power Exchange.
Worked extensively with slowly changing dimensions(SCD) in EDW environment.
Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, system integration and user acceptance testing.
Worked extensively on Agile and Waterfall methodologies.
Experience in UNIX shell scripting, FTP, Change Management process and EFT file management in various UNIX environments.
Performed migration activities, Copy Deployment groups, folders, individual objects and shared objects across repositories (Development to Test and Production).
Coordinating and working with UNIX Admin, DBAs to create and maintain each PowerCenter instance, relational connections etc.
Performed administrative tasks like Repository Backups and restoring. Maintaining folder structures in repository and Server, shutdown and start IS or Repository services using admin console.
Created and controlled the Security over Data Base Connections.
Handled enhancement requests for existing applications on the data warehouse.
Independently perform complex troubleshooting root-cause analysis.
Proficient in understanding business processes/requirements and translating them into technical requirements.
Excellent problem-solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player ability to meet deadlines and work under pressure.
Technical Skills
ETL Tools
Informatica Power Center 10.1/9.6.1/9.5/8.6.1
Databases
Oracle 11g/10g, MS SQL SERVER 2008/2005, DB2, MS Access and Teradata.
Data Modeling
Star Schema and Snow Flake Modeling, Fact and Dimension Tables
Languages
SQL, PL/SQL, Python, UNIX Shell scripting, HTML.
Operating System
UNIX (Sun Solaris, LINUX, HP UNIX, AIX), Windows NT, Windows XP, Windows 7, 8, 10.
Scripting Languages
Shell Scripting, Python Scripting.
Project Experience
AT&T, Richardson, TX Apr 2017 to Till Date
Sr Informatica Developer
AT&T is the world's largest telecommunications company, the largest provider of mobile telephone services, and the largest provider of fixed telephone services in the United States. The warehouse used is Customer 360 degree where we choose the best customers and providing best facilities to customers from all angles.
Responsibilities:
Interacted actively with the business clients and was able to convince them about the proposed fix and the root cause analysis.
Coordinated with the external vendors, upstream and downstream teams for Issues Reported.
Proficient and excellent in handling the tickets with regular updates and follow ups to avoid any back logs.
Experience in implementing the business rules by creating transformations (Expression, Aggregate, Source qualifier, connected and Unconnected Lookup, Router, Rank, Update Strategy, Normalizer) also developing Maplet, worklets and Mappings.
Understanding ETL requirement specifications to develop HLD & LLD for type-1, SCD Type-II and Type-III mappings and was involved in testing for various data/reports.
Experience in Performance tuning mappings, SQL Optimization, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions.
Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
Experience in developing SQL and PL/SQL scripts for relational databases such as Oracle, Microsoft SQL Server, DB2 Experience in UNIX programming and shell scripting for Informatica pre & post session operations and database administration activities.
Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
Issues either in Informatica mappings or the UNIX scripts was handled proactively.
Understanding the project requirements from the ETL Specifications.
Handled issues (From Requirement Gathering, design, development, testing and Production support) for four applications.
Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
Pre and post session assignment variables were used to pass the variable values from one session to other.
Tuned the mappings and involved in performance improvement phase.
Resolving of CR related to Informatica ETL’s, which involves code enhancement or new development of Informatica ETL’s.
Performed unit testing at various levels of the ETL and actively involved in team code reviews.
Identified problems in existing production data and developed one-time scripts to correct them.
Fixed the invalid mappings and troubleshoot the technical problems of the database.
Health First, Lake Mary, FL July 2015 to Apr 2016
Informatica Developer
Health First medical group is a multi-specialty, multi-location medical group serving several communities in USA. The Data warehouse was designed to generate reports for the Human Health Department in Guidant Pharmaceuticals. It reports the historical data stored in various databases like Oracle and Flat Files. Data from different sources was brought using Informatica ETL and sent for reporting using Business Objects.
Responsibilities:
Interacting with business owners to gather both functional and technical requirements.
Understanding and reviewing the functional requirements that, we get from different states with the Business Analyst and signing off the requirement document.
Prepared technical design document as per the functional specification and unit test cases.
Developed and tested Informatica mappings based on the specification.
Design, develop, and test Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
Developed reusable transformations and mapplets to offset redundant coding and reduced development time and improving loading performance both at mapping and at session level.
Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
Processing of Flat file request as adhoc requests by users.
Resolving of CR related to Informatica ETL’s, which involves code enhancement or new development of Informatica ETL’s and enhancements of UNIX scripts.
Created tables in staging to reduce code change in mapping to handle dynamic field positions in the source data files and generating flat file.
Designed and developed strategy for the Workflows and set dependencies between the workflows.
Provide a single data access point for structured and unstructured data by using data virtualization.
Applied the concept of Change Data Capture (CDC) and imported the source from Legacy systems like Cobol using Informatica Power Exchange.
Bug fixing if the JOB fails.
User Acceptance, E2E, Multiple Browser, Regression, and Smoke Testing.
Validated, debugged old Mappings tested Workflows & Sessions and figured out the better technical solutions. Identified the Bottlenecks in old/new Mappings and tuned them for better Performance.
Designed Mappings using B2B Data Transformation Studio.
Parameters Debugging Parameter Issues Matrix Reports and Charts.
Understanding ETL requirement specifications to develop HLD & LLD for type-1, SCD Type-II and Type-III mappings and was involved in testing for various data/reports.
Post migration activities related to Informatica and UNIX environment which involves modification and testing of the Informatica objects and Scripts.
Helped with data profiling, specifying and validating rules (Scorecards), and monitoring data quality using the Informatica Analyst tool.
Migrated Informatica mappings, sessions and workflows from development environment to QA, and checking the developed code into Tortoise SVN for release Exception management.
Maintained all phases of support documents like operation manual, application flows.
Deploy Code from DEV to TEST environment until checked to PROD.
Tuned the mappings and involved in performance improvement phase.
AIG Insurance, Houston, Tx Sep 2014 to June 2015
Informatica Administrator
This Client is one of the largest insurance client in USA. Informatica was equipped as ETL tool with AIX server and DB2. Informatica was used to build and maintain Enterprise data management and data warehouse. Informatica admin team was setup to cater and administer the Informatica server, setup and security and perform essential up-gradation whenever required.
Responsibilities:
Creating users, groups and providing access to group as per the request using Admin console, Managed permissions and privileges for user folders in different environment.
Performed migration activities, Copy Deployment groups, folders, individual objects and shared objects across repositories as per the change request instructions.
Perform administrative tasks like Repository Backups and restoring.
Maintaining folder structures in repository and Server, shutdown and start IS or Repository services using admin console.
Install Informatica patches and analyze and actively respond during DB or other OS outage activities.
Load balancing and addressing queries related to repository table maintenance.
Informatica repository Objects DB Purge process.
Informatica Relational Connections and Maintenance.
Performing maintenance activities whenever there is upgrade on UNIX Servers.
Gilead Sciences, Forest city, CA June 2012 to Aug 2014
Informatica Developer
Gilead Sciences is an American biopharmaceutical company that researches, develops and commercializes drugs. The company focuses primarily on antiviral drugs used in the treatment of HIV, hepatitis B, hepatitis C, and influenza, including Harvoni and Sovaldi. This warehouse is to generate reports and analyze the sales of various products. Data from different sources was brought using Informatica ETL and sent for reporting.
Responsibilities:
Involved in technical design document as per the Business Requirement.
Developed mapping to load data in slowly changing dimensions Update Else Insert and updated the flag columns whenever a record is inserted or updated to identify the current record.
Tested the mappings to view the data got populated according to specified logics in the technical specification document.
Design and develop PL/SQL packages, stored procedure, tables, views, indexes, and functions; implement best practices to maintain optimal performance.
Design, develop, and test Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
Developed reusable transformations and mapplets to offset redundant coding and reduced development time and improving loading performance both at mapping and at session level.
Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
Used Informatica B2B data exchange to structured data like XML.
Provide a single data access point for structured and unstructured data by using data virtualization.
Involved in Unit Testing for the mappings.
Developed several reusable Transformations, Worklets and Mapplets that are used in other mappings.
Tuned the mappings and involved in performance improvement phase.
Maintaining Daily ETL runs.
Used most of the transformations such as the Source qualifier, Router, Filter, Sequence Generator, Expression, Union, Joiner, Dynamic Lookup etc as per the business requirement.
Developed source-target mappings and documented the same.
AGI Glaspac, Hyderabad, India June 2010 to Mar 2012
Jr Informatica Developer
AGI Glaspac is engaged in the manufacture of high quality glass containers to meet the stringent and demanding quality standards for the packaging needs of Food, Pharmaceuticals, Soft Drinks, Spirits, and other industries. This warehouse is to generate reports and analyze the sales of various products. The product data is categorized depending on the product group and product family. It is also used to analyze the usage of product at different times of the year.
Responsibilities:
Understand the business requirement and prepare the POC and provide the ETL solution.
ETL coding using Informatica mapping.
Have worked with various data sources like flat files, XML files and RDBMS Database systems.
Developing Unix shell scripts.
Used most of the transformations such as the Source qualifier, Router, Filter, Sequence Generator, Expression, Union, Joiner, Dynamic Lookup etc as per the business requirement.
ETL mappings retrieve data from operational systems and pre-process it for further analysis by reporting and analytics tools.
Unit and System testing of Informatica mappings.
Environment preparation for SIT/UAT.
Client communication for UAT support or defect fixing.
Education:
Bachelor’s in Electronics Engineering (RVR&JC, India).
Contact this candidate