Resume

Sign in

ETL Informatica Developer

Location:
Princeton, New Jersey, United States
Salary:
$
Posted:
November 27, 2017

Contact this candidate

Resume:

Prudhvi

(ETL Informatica Developer)

Professional Summary

Have 7+ years of experience in ETL tools like Informatica Power center Repository Manager, Power center Designer (Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer), Workflow Manager (Task Developer, worklet designer, workflow designer) and workflow monitor. Web services and security configuration in Informatica server (end-to-end), Power exchange, Power Connect.

Experience working in Financial, Insurance, Healthcare, Supply Chain and Manufacturing projects.

Involved in complete software development life cycle (SDLC) of project with experience in domains like Financial, Insurance, Health care domains.

Experience in Data Warehouse/Data mart, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

Extensively worked on data migration projects to migrate the data from Teradata, Sql Server to Vertica using vsql scripts.

Extensively used Informatica Power Center 9.5/9.1/8.6 (Source Analyzer, Mapplet Designer, Transformation Designer, Star & Snowflake Schemas using Informatica tool on Oracle and SQL Server databases).

Proficient in extracting and transforming data from various sources (Oracle tables & Flat files) into the Data warehouse using ETL tools.

Extensively involved in Performance tuning in Vertica queries as well as Informatica mappings.

Worked in Dimensional Data warehouses in Star and Snowflake schemas and Slowly Changing Dimensions.

Experience in Data warehouse / Data mart implementation with Dimensional Modelling.

Expertise in Extraction, Transformation and Loading of data from multiple sources to the data warehouse.

Experienced in creation of Teradata TPT & BTEQ utilities, VSQL scripts, mappings, mapplets, workflows, worklets, tasks and scheduling of workflows/jobs.

Extensively worked on transformations such as Source Qualifier, Expression, Aggregator, Filter, Router, Joiner, Lookup, Sorter, Sequence Generator, XML Generator, XML Parser and Update Strategy transformations.

Extensively worked in the design of historical load and incremental load mappings to load data on daily and monthly basis.

Proficient in using databases like Oracle 11g/10g and SQL Server.

Performed unit testing at various levels of the ETL.

Possess good interpersonal, communication and problem-solving skills

TECHNICAL EXPERTISE:

Data Warehousing

Informatica Power Center 9.5/9.1/8.6.1/7.1/6.2, (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Informatica Power Connect, DTS, Web services,,

Data Modeling

Erwin, Toad

Databases

Oracle11i/10g/9i/8i/7x, SQL Server 2003/2008, MS Access, Excel, Vertica 3.0/4.0,Teradata.

Languages

SQL, T-SQL, ANSI-SQL, PL/SQL, Unix Shell Script,Visual Basic, ANSI SQL, SQL*Plus 3.3/8.0, JAVA

Tools

Toad, SQL* Loader, Crystal Reports 9.0/8.x/7/6/5/4

Operating Systems

Windows 2007/2005/2003/XP/NT Server and Windows NT, UNIX, HP-UX, UNIX AIX 4.2/4.3, Sun Solaris 8.

Analytical Tools

SQL Server Analysis Service (SSAS), Performance Point Server 2007, ProClarity Analytics Server

SQL Server Tools

Query Analyzer, SQL Server Profiler, SQL Server Mail Service, Enterprise Manager, SQL Server Agent, DTS, BCP, Microsoft Visual Studio

Versioning

Team Foundation Server (TFS), Visual Source Safe (VSS).

Professional Experience:

AT&T, Dallas TX Mar 16 - Till Date

Role: ETL Developer

Responsibilities:

Attended each and every KT session to understand the already existing database and the system.

Worked closely with the client in understanding the business requirements, prepared data analysis and provided the code deliverable.

Extract data from different source Databases (Oracle, MSSQL, Salesforce), transform the data using ETL Informatica Transformations and then load the data into Data warehouse

Extensively used transformation like Filter, router, sorter, aggregator, lookup, source qualifier, expression, update strategy for implementing business requirements.

Worked on dimensional models like Star schema and Snowflake schema.

Analysed Hard and Soft error issues for Production mapping and provided possible solutions.

Created Adhoc mappings for backfilling data.

Work on end to end migration of database from Teradata, Sql Server to Vertica and be involved in SDLC.

Perform initial analysis on the ETL logic present in the each application and creating detailed solution design documents.

Coordinate with various teams to come up with high level, low level design of the project.

Use vsql/bteq/TPT utilities to import data from Teradata, in to SQL using Unix shell scripts.

Implemented performance tuning logic on sources, targets, mappings and sessions to provide maximum efficiency and maximize performance.

Worked extensively with different cache memory in Informatica such as Index cache, Data cache and Lookup cache (Static, Dynamic & Persistence)

Created mapping to load the data into Salesforce database and also automated the flow in the DNA subject area

Data preparation to perform unit testing for some of the critical mappings in Staging Environment.

Performed unit testing on the Informatica code by running it in the Debugger and writing test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance

Monitor the workflows in UAT environment and verify the results match with the business requirement. Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to insert the data from the payload into the database.

Reusing the existing procedures and packages according to our requirement.

Manual testing on all the insert procedures and built the test script and data

Performed Unit testing on all the PL/SQL Packages and procedure, functions according to business requirement.

Create Projections, and partitioning the data and segmenting on different nodes, which makes the database efficient and reliable.

Actively involved in the code review and testing documentation.

Rigorously worked in rapid timings on testing each of the scenarios and bug fixes constantly.

Environment: Informatica Power Center 9.1.1/9.6.1 (Power Center Designer, Teradata, workflow manager, workflow monitor), Oracle 11g,,SOQL,SFDC,TOAD, BTEQ, Windows XP,Reporting Services (SSRS), Vertica 3.0/4.0, MS visual Studio,Vertica

NYMMIS, Albany, NY Jan15 - Mar16

Role: ETL Informatica Developer

Responsibilities:

Participated in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.

Worked closely with the client in understanding the business requirements, prepared data analysis and provided the code deliverable.

Understanding the Business requirements and created Functional and Technical Design documents

Created Informatica Mappings /Sessions/Workflows to load data into Database tables based on business and technical requirement.

Mappings were designed to cater the slow changing dimensions like SCD 1 & SCD2.

Redesigned the existing mappings in the system to meet the new functionalities.

Sound knowledge in using various transformations such as Source Qualifier, Expression, Lookup, Aggregator, Joiner, Sequence Generator, Update Strategy which used to migrate data from various heterogeneous sources like Oracle, Adabas and Flat files.

Analyzed production mapplets and prepared documents for upcoming future developments

Worked on the creation of the dynamic target flat files as per the project requirement.

Used Debugger to validate mappings and troubleshoot information about data and error conditions.

Resolved technical issues in production databases and implemented code fixes in quick pace.

Used workflow monitor to monitor the performance and fine tune the performance if required.

Involved in the unit testing to perform the data is loaded based on business requirement.

Worked with testing Team for preparing test cases for System Testing and supporting for System/integrated testing. Monitor the workflows.

UAT environment and verify the results match with the business requirement.

Environment: Informatica Power Center 9.1.1/9.6.1 (Power Center Designer, Teradata, workflow manager, workflow monitor), Oracle 11g,,SOQL,SFDC,TOAD, BTEQ, Windows XP,Reporting Services (SSRS), Vertica 3.0/4.0, MS visual Studio.

CGI Information Systems, Bangalore Oct13 - Aug14 ETL Developer

Responsibilities:

Involved in Data Analysis to extract useful data, finding patterns and regularities from the sources and develop conclusions.

Understanding the Business requirements and created Functional and Technical Design documents

Created Informatica Mappings /Sessions/Workflows to load data into Database tables based on business and technical requirement.

Mappings were designed to cater the slow changing dimensions like SCD 1 & SCD2.

Redesigned the existing mappings in the system to meet the new functionalities.

Sound knowledge in using various transformations such as Source Qualifier, Expression, Lookup, Aggregator, Joiner, Sequence Generator, Update Strategy which used to migrate data from various heterogeneous sources like Oracle, Adabas and Flat files.

Analysed production mapplets and prepared documents for upcoming future developments

Worked on the creation of the dynamic target flat files as per the project requirement.

Used Debugger to validate mappings and troubleshoot information about data and error conditions.

Resolved technical issues in production databases and implemented code fixes in quick pace.

Used workflow monitor to monitor the performance and fine tune the performance if required.

Involved in the unit testing to perform the data is loaded based on business requirement.

Worked with testing Team for preparing test cases for System Testing and supporting for System/integrated testing.

Environment: Informatica Power Center 9.1.0(Repository Manager, Designer, Workflow Manager, and Workflow Monitor), web logic 8.1.0,Windows XP, Oracle 10g, DB2, Power Exchange 8.6, Teradata 13,, PL/SQL Developer, SQL Plus .

Yash technologies, Hyderabad Sep11 - Oct13

Role: Informatica ETL Developer

Responsibilities:

Involved in Data Analysis to extract useful data, finding patterns and regularities from the sources and develop conclusions.

Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.Actvly involved in Data Warehouse system design discussions.

Extensively used various transformations like Lookup, Update Strategy, Joiner, Aggregator, Union and few other transformations.

Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for capturing Delta loads.

Involved in creating Fact and Dimension table mappings to load Fact and Dimension tables.

Developed Slowly Changing Dimension (SCD) Type1, Type2, and Type3 mappings.

Worked with Reusable Mappings (Mapplets), Reusable Workflows (Worklets) and Reusable Transformations.

Worked with Session Logs, Informatica Debugger, and Performance Logs for error handling the workflows and session failures.

Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative.

Worked with tools like TOAD to write queries and generate the result.

Developed restart token on UNIX server for Real-time Informatica workflows and customized real-time Power Exchange workflows.

Used SQL Override in Source qualifier to customize SQL and filter data according to requirement.

Wrote PRE and POST SQL commands in session properties to manage constraints that improved performance.

Performed Pushdown Optimization to increase the read and write throughput

Wrote SQL queries and PL/SQL procedures to perform database operations according to business requirements.

Document all ETL related work per company's methodology.

Involved in system end to end testing (Unit and System Integration Testing) as part of the SDLC process and performance tuning at the mapping level, session level, source level, and the target level.

Prepared estimates and tracked each and every task and strictly adhered to the estimated deadlines.

Environment: Informatica Power Center 9.1/8.6 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Windows XP, Oracle 10g, DB2, Power Exchange 8.6, Teradata 13, TOAD, PL/SQL Developer, SQL Plus, OBIEE 10g, Sun Solaris.



Contact this candidate