Data Integration Warehouse

Location:

Texas City, TX

Posted:

July 29, 2025

Contact this candidate

Resume:

Ravikumar Sunka

ETL Lead

D: +1-302-***-**** Email Id: ****@********.***

Summary:

Skilled and results-driven Data Integration and ETL Developer with over 14+ years of experience in designing,

Developing, and implementing data integration solutions using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS). Proficient in ETL processes, data transformation, and cloud- based solutions with a strong focus on data quality and optimization. Adept at collaborating with cross- functional teams to deliver complex data integration solutions, ensuring high-performance and scalability.

Designed and implemented efficient ETL architectures using IICS & Informatica PowerCenter to extract, transform, and load data from diverse sources into target systems.

Implemented end-to-end data integration solutions using Informatica Intelligent Cloud Services (IICS) platform, facilitating seamless data movement between on-premises and cloud environments.

Utilized IICS API integration capabilities to connect diverse applications, enabling real-time data exchange and event-driven actions.

Hands-on experience working on end-to-end data integration projects, from requirement gathering to deployment, using IICS & Informatica PowerCenter.

Strong experience in ETL Designing, Data Conversion, Data Warehouse, Data Mart Design, Star Schema and Snowflake Schema methodologies, Unit Testing and Documentation.

Proficient in understanding business processes / requirements and translating them into technical design.

Experience in designing and development of ETL Methodologies using Informatica PowerCenter 9.6.1/9.0.1/8.x, Informatica PowerExchange 9.6.1/9.0.1, and Informatica DataQuality 9.6.1.

Spearheaded data quality initiatives by performing data profiling, cleansing, and validation using IICS data quality tools, resulting in a significant improvement in data accuracy and consistency.

Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Aggregator, Sequence Generator and Sorter.

Extensive experience in Administration and Maintenance of Dev, Stage, Prod, and standby databases for DSS and Data Warehousing environments.

Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data Management, Data Transportation and Data Staging.

Five Years of experience in Teradata data base design, Implementation and Maintenance mainly in large-scale Data Warehouse environments.

Expertise in designing and developing Workflows, Sessions and other tasks using Workflow manager tools - Task Developer, Workflow & Worklet Designer to handle different load scenarios.

Experience in working with various heterogeneous Source Systems like MySQL, Oracle, SQL Server, DB2, Flat files.

Extensively worked with BTEQ, FASTEXPORT, FASTLOAD and MULTILOAD Teradata utilities to export and to load data to/from flat files.

Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.

Expertise in Query Analyzing, performance tuning and testing.

Extensive experience in loading high volume of data, implementing complex business rules by creating Mappings with reusable transformations and Mapplets also tuned them for Optimum performance.

Hands on experience in monitoring and managing varying mixed workload of an active data warehouse using various tools like Teradata Workload Analyzer and Teradata Visual Explain.

Extensively worked on Query tools like SQL Assistant, TOAD and PLSQL Developer.

Hands on experience in Star/Snowflake schema design and De-normalization techniques.

Proficient in converting logical data models to physical database designs in Data warehousing Environment and in-depth understanding in Database Hierarchy, Data Integrity concepts and Data Analysis.

Worked on IICS for cloud-based data integration, data quality, and master data management solutions. Ability to design and deploy scalable in IICS

Extensive experience working in agile environments, providing timely updates and adhering to delivery deadlines.

Experience in integrating cloud-based data sources and ensuring seamless data flow between on- premise and cloud systems.

Strong expertise in IICS & Informatica PowerCenter for ETL processes to review the Informatica code, Design Document thereby to deliver quality assurance, regulatory compliance, and security.

Collaborate with business analysts, data architects, and project teams to define requirements and technical specifications for data integration processes.

Strong problem-solving skills and experience in debugging and resolving complex data integration issues

Experience in performance tuning and optimization of ETL processes

Experience working in Scrum/Kanban teams.

Participation in daily stand-ups, sprint planning, retrospectives, and backlog grooming.

Experience in estimating story points for data engineering tasks like ETL pipeline development, database design, and data warehousing.

Solid understanding of data warehousing concepts and dimensional modelling.

Knowledge of integrating relational databases, flat files, and cloud sources (AWS, Azure, etc.)

Highly proficient in processing tasks, version control, scheduling sessions, Import/export repositories, manage users, groups associated privileges and folders

Experience in documenting High level Design, Detailed Technical Design, Code review, Unit test plan, Unit test cases, Development, and support handover documents.

Hands-on experience on ETL Batch support, identifying issues, resolving issues related to files, data, tables, or Informatica side issue

Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Router and Update Strategy transformation.

Certifications:

●AZ-104: Microsoft Azure Administrator

Technical Skills: