Summary
Overview
Work History
Education
Skills
Timeline
Generic

Roopesh V

ETL Developer

Summary

Results-driven Data Warehouse professional with over 9 years of IT experience specializing in ETL solutions, data warehousing methodologies, and the full SDLC. Skilled in designing and developing ETL processes using Informatica Powercenter and IICS to extract data from various sources and load it into target databases like Oracle, IBM Netezza, and GCP. Proven track record in identifying performance bottlenecks, implementing error handling strategies, and proficient in relational database management systems and complex SQL queries. Experienced in Python development, familiar with CI/CD principles, GitHub Actions, and Code Management practices. Seeking a challenging role to apply expertise in driving data-driven decision-making.

Overview

11
11
years of professional experience
6
6
years of post-secondary education

Work History

IICS Developer

American Express
06.2022 - Current
  • Collaborated with business analysts to gather requirements and define functional specifications for data warehousing projects.
  • Designed and developed ETL mappings using Informatica PowerCenter to transform data according to business rules.
  • Utilized Informatica PowerCenter 10.5 and IICS for data ingestion processes.
  • Led end-to-end database migration from IBM Netezza to Google Cloud Platform, enhancing data processing efficiency and scalability.
  • Implemented ETL workflows using Informatica PowerCenter for data extraction, transformation, and loading from Netezza to GCP services.
  • Developed reusable Informatica mappings and sessions to manage complex transformation logic and ensure data integrity.
  • Worked with cloud engineers to configure secure data pipelines between on-premises Netezza and GCP storage.
  • Conducted extensive data validation, reconciliation, and performance tuning to ensure high-quality data migration with minimal downtime.
  • Automated daily data loads and incremental migrations using PowerCenter workflows and scheduling tools.
  • Optimized SQL queries for compatibility and performance during the Netezza to GCP transition.
  • Documented migration processes, data lineage, and best practices for ongoing cloud data warehouse initiatives.
  • Experienced with using Cloud Databases.

Informatica Cloud Developer

Smart Stream
09.2020 - 06.2022
  • Served as an ETL Designer, gathering business requirements, scoping projects, and performing gap analysis.
  • Translated user requirements into system solutions and data architecture documentation.
  • Collaborated with Business Analysts and DBAs for requirements gathering and infrastructure development.
  • Ensured project teams understood data quality standards, architecture guidelines, and designs.
  • Designed and optimized database architecture, complex queries, and stored procedures for OLAP and unstructured data services.
  • Prepared Technical Specification Documents and Source-to-Target ETL mapping Documents.
  • Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files, and Persistent Cache.
  • Used Python panda's library to convert JAR files.
  • Created Python scripts to create on-demand Cloud Mapping Tasks using the Informatica REST API.
  • Configured and managed IICS connections with AWS Redshift for secure and efficient data transfers.
  • Performed data validation and quality checks post-ingestion to maintain data integrity within AWS Redshift.
  • Integrated IICS ETL solutions with business intelligence and reporting tools.
  • Supported team members in programming, reviewing, and coding ETL applications.
  • Created Python scripts to start and stop cloud Tasks using Informatica Cloud API calls.
  • Executed unit and system testing during code migration from development to production.
  • Developed CDC load process for moving data from Peoplesoft to SQL Datawarehouse using 'Informatica Cloud CDC for Oracle Platform.'
  • Developed complex Informatica Cloud Task flows (parallel) with multiple mapping tasks and task flows.
  • Wrote UNIX shell Scripts & PMCMD commands FTP of files from remote servers and repository/folder backups.
  • Involved in performance tuning at source, target, mappings, sessions, and system levels.
  • Prepared migration documentation for moving mappings across environments.
  • Worked on Informatica Code Migration across various Environments.

ETL Informatica Developer

Florida Power & Light
01.2018 - 08.2020
  • Created Informatica mappings using various transformations (XML, Source Qualifier, Expression, Lookup, Stored Procedure, Aggregate, Update Strategy, Joiner, Normalizer, Union, Filter, and Router) in Informatica Designer.
  • Participated in all phases of SDLC, including design, code, test, and deployment of ETL components for data warehouse and integrated Data Mart.
  • Identified and eliminated duplicate datasets and performed Columns, Primary Key, and Foreign Key profiling using IDQ.
  • Created mappings using pushdown optimization for superior performance in loading data into Oracle.
  • Designed auto-purging methods to free up space from databases.
  • Developed SQL queries using joins, sub-queries, and analytic functions to pull data from relational databases.
  • Designed, installed, configured, and built Oracle's pre-built Analytics applications and created customizations.
  • Developed stored procedures, functions, and database triggers using PL/SQL.
  • Created and edited custom objects and custom fields in SAP.
  • Wrote Unix Shell Scripts to archive files and used UNIX scripts for file management and FTP processes.
  • Worked closely with DBAs, application, database, and ETL developers for migrating mappings to production.
  • Provided production support for the Informatica process, troubleshooting and debugging errors.
  • Utilized Control M for job scheduling and orchestration.

ETL Informatica Developer

Medtronic
09.2016 - 12.2017
  • Created Mappings using Mapping Designer to load data from various sources, using transformations like Unconnected/Connected lookups, Router, Aggregator, Joiner, Stored Procedure, Update Strategy for Daily Load.
  • Designed and Developed Mappings for implementing CDC by tracking changes in critical fields.
  • Created Sessions and Batches for data loads using Workflow Manager for Daily load.
  • Worked on Performance Tuning of various mappings and sessions.
  • Prepared ETL mapping Documents and Data Migration documents.
  • Worked with Tuning the SQL Statements and Database.
  • Involved in Unit testing and User Acceptance Testing.
  • Prepared and used test data/cases to verify accuracy and completeness of the ETL process.
  • Maintained issue log of the issues during the UAT phase.
  • Involved in Migration of the project from Development to Test and Production.
  • Actively involved in production support.

ETL Informatica Developer

Value Labs
05.2014 - 12.2014
  • Experienced with Full SDLC of DWH project.
  • Worked with Business Analyst in understanding STM.
  • Performed Extraction, Transformation, and data loading using Informatica & stored procedures.
  • Based on the requirements, created Functional design documents and technical design specification documents for ETL.
  • Created tables, views, indexes, sequences, and constraints.
  • Involved in testing of Informatica Objects, Stored Procedures, and Functions.
  • Designed and developed table structures, stored procedures, and functions to implement business rules.
  • Used legacy systems, Oracle, and SQL Server sources to extract and load data.
  • Involved in design and development of data validation, load process, and error control routines.
  • Involved in tuning ETL objects and eliminated bottlenecks.
  • Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Education

Bachelor of Science - Computer Science Engineering

Gitam University
Hyderabad
08.2010 - 12.2014

Master of Science - Information Systems Security

University of The Cumberlands
Williamsburg, KY
01.2015 - 08.2016

Skills

ETL Tools: Informatica PowerCenter (102/96), Informatica Intelligent Cloud Services (IICS), Talend Data Integration

Data modeling Tools: Erwin 42

RDBMS: Oracle (11g/10g/9i), Netezza, DB2, PostgreSQL, Yellowbrick

Cloud Databases: Snowflake, AWS Redshift, GCP

Languages: SQL, PL/SQL, Python (panda's library)

Scripting: Unix Shell Scripting, Perl Scripting

Operating Systems: Windows, UNIX (Sun Solaris, Linux)

Scheduling: Control-M, Automic, Airflow

Project Management: Jira, Rally, Confluence

Ticketing: ServiceNow

Other: SQL

Timeline

IICS Developer

American Express
06.2022 - Current

Informatica Cloud Developer

Smart Stream
09.2020 - 06.2022

ETL Informatica Developer

Florida Power & Light
01.2018 - 08.2020

ETL Informatica Developer

Medtronic
09.2016 - 12.2017

Master of Science - Information Systems Security

University of The Cumberlands
01.2015 - 08.2016

ETL Informatica Developer

Value Labs
05.2014 - 12.2014

Bachelor of Science - Computer Science Engineering

Gitam University
08.2010 - 12.2014

Similar Profiles

CREATE PROFILE
Roopesh VETL Developer