Sr.Informatica Developer

CHIRAG DESAI Email- ************@*****.***

Sr.INFORMATICADEVELOPER Contact number-541-***-****

SUMMARY:

Over 9 years of experience with system design, development, testing support and production support Data Warehousing which involves ETL, Reporting and Data modeling experience.

Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.

Proficient in Optimizing Database querying, data manipulation and population using SQL PL/SQL and Utilities in Oracle 11g/10g/9i, DB2 UDB and SQL Server 2008/2000 databases.

Hands on experience with Informatica administration and various upgrades.

Experience of leading and managing mid-size team and coordination of Onsite-Offshore team.

Experience in Data Warehouse/Data Mart Development Life Cycle and worked on Dimensional modeling of STAR, SNOWFLAKE schema, OLAP, Fact and Dimension tables.

Experience writing and modifying ETL design documentation, test results documentation and standard operating procedures (SOP) documentation.

Experience on loading data from various data sources and legacy systems into Teradata production warehouse using utilitiesBTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD.

Experience in writing, testing and implementation of the OraclePL/SQL triggers, stored procedures, functions, packages.Experienced in UNIX work environment, file transfers, job scheduling and error handling.

Worked on Incremental loading Target databases using SCD Type1/Type2 loads.

Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

Extensive hands-on experience in Extraction, Transformation and Loading, DataMigration and Data Conversion Projects.

Excellent technical and analytical skills of OLTP.

Dimensionmodeling for OLAP, ERmodeling&Databasedesign.

Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms, experience with UNIX command line and LINUX.

Worked on CDC using InformaticaPowerExchange to load data in Real-time mode.

Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.

Knowledge of running software tests using Quality Center, Quick Test Professional, and Load Runner.

Excellent analytical/communication skills and good team player.

Technical Skills

ETLTools: InformaticaPowerCenter9.x/8.x/7.x,InformaticaPowerExchange 9.x/8.x/8.x

Databases: Oracle 11g/10g/9i, SQL Server 2008/2005/2003/2000, DB2 UDB 7.2, My SQL 5.0/4.1, MS-Access. Editors (SQL Navigator, Toad),Teradata 13/12/V2R5

Oracle Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10g

Data Modeling: ERWIN 7.1/4.5, MS Visio

Reporting Tools: OBIEE 10g, Business Objects XI

Programming Skills: C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, PERL, JAVA (Eclipse IDE and Net Beans IDE), HTML, JAVA Script, J2EE, CSS.

Operating Systems: UNIX, LINUX, HP, SunSolaris 2.x/7/8, Windows 2007/XP, IBM AIX

EDUCATIONALQUALIFICATIONS:

BE in Computer Engineering, L.C. Institute of Technology, Gujarat, India May 2007

PROFESSIONAL EXPERIENCE:

Salesforce, San Francisco, CA September 2015 - Present

Informatica Developer

Responsibilities:

Analyzing highly complex business requirements, designing and writing technical specifications to design or develop ETL processes.

Automating the ETL process through scheduling the exception-handing routines as well as source to target mapping development, support and maintenance.

Loading Data to the Interface tables from multiple data sources such as Salesforce environment, Oracle server, Text files and Excel Spreadsheets using Informatica and Salesforce connections.

Extracting the data from EDW which is Salesforce Environment and loading into Oracle database. Also working on the sources like Flat files, XML files and loading them to the appropriate Targets. Providing clean data to OBIEE team to generate their reports.

To get the ETL (Extract, Transform and Load) process created to gather data from vendors, stage the data from the Staging layer, to ODS (Operational Data Store) where the data is cleansed and finally into the EDW (Enterprise Data Warehouse) on top of which the Dashboard reports are created for users so that the data could be used for analysis purposes.

Work with other team members and co-ordinate data flow into the EDW.

Worked on Incremental/Historical loading Target databases using SCD Type1/Type2 loads.

Develop and maintain UNIX shell scripts for ETL job automation process.

Helped the team in analyzing the data to be able to identify the data quality issues.

Creating mappings to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, Normalizer, Filter and Router transformations, Union transformations, etc.

Creating the job schedule component using Tidal.

Code Migrations to Main Development folders, Test and SIT repository.

Performance Tuning by adding hints and session level partitions.

Perform Quality Assurance on the ETL code and Database objects and help migrate it to higher environments like SIT and PROD.

Creating the change request that need to be migrated into PROD.

Simplified the data flow by using a Router transformation to check multiple conditions at the same time.

Creating sessions, sequential and concurrent batches for proper execution of mappings using workflow manager.

Using Informatica Designer designed and developed Source Entities and Target warehouse Entity for Oracle.

Involving in versioning the whole process and retiring the old records using the built-in’s DD_UPDATE, DD_DELETE, and DD_INSERT.

Optimizing Query Performance, Session Performance and Reliability.

Designing Database schemas using ER Studio Design Tool.

Worked on Agile methodology and Played Scrum master role on rotation basis.

Environment: Informatica Power Center 9.5.1, Oracle 11g, UNIX Server, TOAD, SQL Devloper, Winscp,Filezilla, Putty, Tidal, UNIX Shell Scripting, Flat Files.

T-Mobile (Kineticom Inc. ) Austin, TXSeptember 2013–August 2015

Senior Informatica Developer

Brief: With a solid record of successful project completion, the Kineticom team deploys the people, process and technology expertise necessary to design and deliver high value solutions that address our clients’ needs and uniquely position them ahead of the competition.

Responsibilities:

•Worked with business analyst for requirement gathering, business analysis, and testing and project- coordination.

•Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.

•Analyzed the existing mapping logic to determine the reusability of the code.

•Handled versioning and dependencies in Informatica.

•Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.

•Created InformaticaPowerExchangeRegistration and Datamap to capture data in real-time and batch mode.

•Performing ETL & database code migrations across environments using Harvest and Deployment group.

•Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.

•Involved inperformance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

•Developed various Teradata utilities like FASTLOAD, MLOAD and TPUMP to load data to staging area.

•Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.

•Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test & supported the UAT for the client.

•Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.

•Coordinated Onsite and Offshore team and tracked the work.

•Created various types of reports using OLAP tool OBIEE.

•Worked on Agile methodology and Played Scrum master role on rotation basis.

Environment: Informatica Power Center 9.5/9.1,Informatica Power Exchange 9.5/9.1, Teradata 13, Toad, UNIX Shell Scripting, Oracle 11g, SQL Server 2008, Flat Files, DB2 Mainframe, Mercury Quality Center, Rally.

Pfizer, Peapack, NJ July 2012- June 2013

Senior Informatica Developer

Brief:The aim of the Digital Mail project was to develop and maintain Data Marts. Data was sourced from different sources like Oracle, SQL Server, Flat files on daily and monthly basis and populate the Data Warehouse.

Responsibilities:

•Gathered Business requirements by interacting with Business Analyst team and analyzed the requirements to translate into Technical Specifications.

•Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.

•Performed complex defect fixes in various environments like UAT, QAetc to ensure the proper delivery of the developed jobs into the production environment.

•Responsible to write complex SQL queries and PL/SQL procedures to perform database operations according to business requirements.

•Worked with the testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project, and also fixed the defects before moving the jobs into production.

•Documented all ETL related work per company's methodology.

•Attended production implementation calls and coordinated with the build engineers during migration of the code and was highly acknowledged.

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

•Co-ordinated with Off-Shore team in INDIA.

•Knowledge ofpromoting packages (code) across development, test, preproduction and production.

•Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.

•Involved in different Team review meetings.

•Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.

•Communication with the client for weekly status report.

Environment: Informatica Power Center 9.1,Informatica Power Exchange 9.1, SQL Server, OracleExadata, Toad, UNIX Shell Scripting, DB2 Mainframe, Mercury Quality Center, Nodejs, Extjs, javascript.

S.USA Life Insurance Company, New York, NY February 2009- Jun 2012

Informatica Developer/Production Support Analyst

Brief:S.USA isone of the oldest life insurance companies in NY. The purpose of this Envision project was to generate reports to help the company to reach out to possible future customers and clients of their provided services which is different types of life insurance and annuities.The project aimed at maintenance of ATR, MTS, and OTC mappings in Envision project. These mappings are related to sales, policy deliverables, claims and investment.

Responsibilities:

•Invelved in Data Modeling and Datawarehouse design as per business requirements.

•Created Dimension Tables and Fact Tables based on the Model design.

•Used Informatica user defined functions to reduce the code dependency.

•Handled versioning and dependencies in Informatica.

•Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.

•Performing ETL & database code migrations across environments.

Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.

Created LDM and PDM through ERWIN and documented description of each components like Tables, columns, Indexes, Constraints and Dependencies.

Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates.

Integrated various sources into the Staging area to Integrate and Cleansing data.

Involved in identifying bugs in existing mappings by analysing data flow, evaluating transformations using Debugger.

Worked extensively on designing Data Mapping flow from various source systems to target systems

Involved in identifying Informatica bottleneck and Tuningvarious components of designer and workflow manager.

Developed Teradata Scripts to write data into flat files and then loaded data from flat files tocustom tables through FastExport, FastLoad and Mload.

Created report generator script through Teradata Bteq Scripts.

Created Stored Procedures, Triggers, Functions, Views and Packages using PL/SQL.

Worked on test cases and test plans. Migrated the code across various environments.

Provided production support by running the jobs and fixing the bugs.

•Documented the process for further maintenance and production support.

Environment: Informatica Power Center 8.6/8.1, Teradata V2R6, Unix Shell scripting, Oracle 11g, SQL Server 2008, SQL, PLSQL, XML,Webservices, MQ Series, WinSCP, DB2 Mainframe, SCM, Linux, Filezilla, Putty.

Sovereign Bank, Brooklyn, NY Sep 2007- Jan 2009

Informatica Developer

Brief:SovereignBank is a foreign-based financial institution which operates 420 full-service banking centers. Through five major lines of business – Corporate Banking, Retail Banking, Community Banking, Consumer Finance and Wealth.Management- Compass offers customers unique and industry-leading products and services.

The aim of the project was to create a Data Warehouse that would involve source data from different departments like Finance, Sales and Marketing and provide complete analytical solutions. Decisions are based on the reports produced using the Data Warehouse.

Responsibilities:

Designed mappingdocument, which is a guideline for ETL Coding following Standards for naming conventions and Best Practices were followed in mapping development.

Extensively used Informatica version tasks like Decision, Command, Event Wait, Event Raise, and Email.

Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.

Optimized the sql override to filter unwanted data and improve session performance.

Used Debugger to track the path of the source data and also to check the errors in mapping.

Prepared unit testing document covering field to field’s validations and source to target count.

Scheduling the workflow comprising of different sessions for their respective mappings in order to load data into Oracle database.

Handled creation, modifications, and documentation of Oracle Packages, Procedures, Functions, and Indexes.

Assisted the other ETL Developers in resolving complex scenarios.

Involved in promoting the folders from Development to Test and Test to Production Environment.

Involved in different Team review meetings.

Environment: Informatica Power Center 8.6, Oracle 10g, Toad 7.6, Autosys, Teradata, PL/SQL, SQL*Plus, SQL*Loader, XML, Windows NT 4.0, Cobol, DB2, Sun Solaris Unix 2.6, Unix Shell Scripting.

Contact this candidate