SUMMARY:

• Around 7+ years of IT experience in Design, Development and implementation of ETL applications and worked extensively to build ETL applications using the technologies Informatica, Oracle, DB2.
• Excellent Data modeling knowledge in Dimensional Data modeling (Star and Snow - Flake Schema’s), Physical and logical data modeling and De-normalization techniques.
• Extensive experience in SQL programming and strong relational database knowledge including the ability to write complex queries, analyze, optimize and debug queries.
• Strong experience in writing complex SQL for Oracle 11g.
• Involved in requirement gathering, development, testing, peer reviews, debugging, deployment and documentation.
• Involved in design phase of the ETL Data load framework and the overall design of the ETL process, to make the jobs more scalable and expandable for future releases.
• Experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database administrators.
• Involved in design and architecting the ETL Data load framework and the overall design of the ETL process, to make the jobs more scalable and expandable for future releases.
• Strong experience in performance tuning of the ETL code which are used for loading the data into DWH.
• Involved in the Logical and Physical Data modeling.
• Involved in writing shell UNIX Shell scripts for automating ETL jobs.
• Strong experience in Data warehouse principles and design methodologies possess strong knowledge in multiple ETL tools and platforms.
• Has strong experience in writing PL/SQL Stored Procedures.
• Good experience of Agile/scrum development software methodology
• Good knowledge on Salesforce data extraction through Power exchange.
• Strong Team work and collaboration skills.
• Good communication and analytical skills with very good experience in programming and problem solving.

TECHNICAL SKILLS

ETL: Informatica 9.6/9.1/8.5, IBM DataStage 8.X, 7.5 x.

Databases: Oracle 11/10g.

Data Modelling: Logical, Physical, Dimensional Data Modeling, Star and Snowflake Schema’s

Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating Systems: UNIX/Linux, Windows

Version Control: GitLab

Defect Tracking Tools: HP Quality center

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Senior Informatica Developer

Responsibilities:

• Worked with product owners / business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Designed and developed Informatica Workflows / mappings to extract the data from external source systems and load into CCMI data layer.
• Created stored procedures to implement the complex business requirements.
• Developed Unix Shell scripts to automate the ETL process
• Designed and developed Informatica mappings using Lookup, Joiner, Aggregator, Router and Update strategy transformations. etc.
• Responsible for performance tuning of the ETL process.
• Extensively worked on Git Lab for version controlling.
• Provided support to the QA team to run all the respective objects in DEV, UAT environments during scheduled Cut-over’s at various phases of the project.
• Write and Optimize complex SQL queries for better performance of ETL jobs.
• Delivering New Enhancements to the existing applications.
• Actively participated PI planning sessions and sprint daily stand-up and retrospective meetings in the agile process.
• Conducted knowledge Transfer sessions to the new team members in the project.

Environment: Informatica 9.6, Oracle 11g, Teradata, OBIEE, UNIX, Rally, CA ESP, GitHub, Jenkins, Udeploy.

Confidential, Phoenix, AZ F

Senior Informatica Developer

Responsibilities:

• Actively participated in the client meetings to gather the business requirements.
• Actively participated Agile scrum sprint planning/retrospective/status meetings for sizing the stories/update the status to project team.
• Extensively designed /developed Informatica mappings that transfer the data from Source to Target systems for Claims Fraud Analysis.
• Designed and developed complex SQL queries using Oracle /DB2 Database.
• Involved in creating / modifying database tables to fit into the existing Data Model.
• Involved in creating Unit test case documents and peer review activities to maintain project quality standards.
• Actively participated in giving the code / data results demo to Product owners.
• Involved in Performance Monitoring and Tuning.
• Developed the ETL code to handle dynamic data retrieval from source systems.
• QA Support and deployment support

Environment: Informatica 9.6, Oracle 10g, DB2, Linux, Control-M, -GitLab.

Confidential

enior Informatica Developer

Responsibilities:

• Actively participated in the client meetings to gather the business requirements.
• Worked on multiple modules with different business units including Insurance actuaries.
• Worked with ETL architects and Business Analysts to prepare the ETL design docs and unit test plans.
• Involved in data profiling, analyze data and make recommendations for improvements.
• Analysis, design, deployment, coding and testing of Data warehousing using Informatica (ETL) on OLAP and OLTP environment and implementation of Database Management Systems.
• Extracted FACTS (Claims data) from SAP systems and populated to EDW tables.
• Preparing the mapping documents by understanding the existing source systems.
• Created Informatica Mappings usingMapping Designerto load the data from heterogeneous sources, using various transformations.
• Created, scheduled, and monitored workflow sessions on the basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Fine-tuned performanceof Informatica mappings and sessions.
• Worked with Data Modeler and DBAs to build the data model and table structures.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
• Developed UNIX shell scripts to scheduling Scripts by using scheduling tools.
• Worked with production issues like bottlenecks, data validation and report errors.
• Involved in creating Test scenarios, preparing Unit Test cases, supporting UAT activities.
• Responsible for creating Migration documents to move code from Dev to QA Environment.

Environment: Informatica 9.6 / 9.1, Oracle 11g, Flat Files, IBM DB2, OBIEE, UNIX, CA7.

Confidential, Manhattan, NY

Senior ETL Developer

Responsibilities:

• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Developed Reusable Transformations, Source and Target definitions, mappings using Informatica.
• Requirements analysis, data assessment, business process reengineering.
• Involved in complete SDLC (System Development Life Cycle).
• Supporting the legacy ETL process which is developed on Informatica/Netezza.
• Designed and developed Informatica mappings using Lookup, Joiner, Aggregator, Router and Update strategy transformations.
• Tuned SQL statements and analyze query performance issues.
• Performance tuning of Informatica ETLs for existing applications.
• Used Load utilities (NZ Load) to load data from flat files to Netezza tables.
• Data reconciliation activities between Source and EDW Teradata databases
• QA Support and deployment support.
• Involved in code peer review activities to maintain project quality standards.

Environment: Informatica 9.1, Oracle 10g, Netezza, UNIX, Tidal Scheduler

Confidential

Oracle Developer

Responsibilities

• Used ODBC to connect to the target Oracle database
• Created Oracle stored procedures, functions and triggers using PL/SQL
• Enhanced technical writing skills
• Managed data conversions and load processes
• Performance tuning of oracle PL/SQL scripts
• Managing the Table Spaces, rollback segments and indexes for applications.
• Created database objects including Tables, Views, Synonyms, Indexes, Clusters and Sequences
• Granting/Revoking various privileges/roles to users and applications.
• Managed the table spaces, rollback segments and indexes for applications
• Conducted performance tuning of Oracle queries and stored procedures
• Loaded data into Oracle using SQL *Loader
• Wrote stored procedures and queries using SQL to retrieve the data that satisfy the business needs.

Environment: Oracle 8i/8.x (PL/SQL, SQL* Loader, SQL Forms 4.5, SQL Plus, SQL Loader, Oracle Reports 2.5), Windows NT, SQL, PL/SQL, UNIX Shell Scripting, Sun Solaris, Sun Classic.