Vijay Reddy

Vijay Reddy Email and Phone Number

Informatica IDMC ETL Lead Developer @ Capgemini
Bartlesville, OK, US
Vijay Reddy's Location
Houston, Texas, United States, United States
About Vijay Reddy

Twelve plus years of IT experience with a strong background in SDLC, Data Integration tools including Informatica PowerCenter, Informatica Cloud Integration tools (Cloud Data Integration & Cloud Application Integration), Informatica Administration, Informatica Data Quality/MDM and Business Intelligence tools like Power BI and Business Objects etc.Worked as a Senior ETL developer (IICS/Informatica/Snowflake) in ConocoPhillips. Under the Integration platform, where provides the Integration solutions to various Business Units to integrate the data from various source systems and applications for reporting and data analysis. Developing comprehensive integration strategies aligning with business objectives and technology roadmaps. Evaluating existing systems and proposing integration enhancements for optimized performance.Implementing ETL processes, data pipelines, and synchronization mechanisms for real-time and batch data movement. Ensuring data accuracy, integrity, and compliance.Extensive experience with middleware platforms such as Informatica intelligent cloud services (IICS), Informatica PowerCenter, Data Quality/MDM, DataStage and Pentaho etc. Designing and configuring integration flows to facilitate seamless data exchange.Worked on various with cloud-based data solutions including Snowflake, AWS S3, Azure Blobs & on-promise databases including Teradata, Oracle, SQL Server, DB2 and SAP R/3 etc.Worked with different types of file structures like flat files, csv, excel, xml, Json, parquet etc.Developed cloud integration parameterized mapping templates (Snowflake) for Stage, Dimension (SCD Type1, SCD Type2, CDC and Incremental load) and fact load processes.Good experience in developing cloud application integration processes using SOAP/REST APIs, APIs leveraged to integrate multiple systems.Good experience in performance tuning and debugging of existing ETL processes.Hands on experience working on profiling data using IDQ.Hands on experience in Unix shell and Python scripting.Good knowledge in Azure Data Factory.Collaborating with cross-functional teams to define end-to-end integration solutions. Balancing technical requirements, performance goals, and user expectationsDevOps Integration -Integrating CI/CD pipelines, automated testing, and deployment processes to ensure continuous integration and delivery of integration solutions.

Vijay Reddy's Current Company Details
Capgemini

Capgemini

View
Informatica IDMC ETL Lead Developer
Bartlesville, OK, US
Website:
capgemini.com
Employees:
321265
Vijay Reddy Work Experience Details
  • Capgemini
    Informatica Idmc Etl Lead Developer
    Capgemini
    Bartlesville, Ok, Us
  • Conocophillips
    Senior Iics Etl Developer
    Conocophillips
    Bartlesville, Ok, Us
  • Conocophillips
    Informatica/Iics Lead
    Conocophillips Jun 2023 - Present
    Houston, Texas, United States
    - Working as a Senior ETL developer (IICS/Informatica/Snowflake) in ConocoPhillips. Under the Integration platform, developing comprehensive integration solutions aligning with business objectives and technology roadmaps to various Business Units to integrate the data from various source systems and applications for reporting and data analysis. - Evaluating existing systems and proposing integration enhancements for optimized performance. - Lead and/or participate in gathering and evaluating requirements, working with application / Data Warehouse team and project managers to provide solutions to end users. - Created the technical design documents and ETL mapping documents based on the business and functional requirement. - Designed and developed mappings, mapping tasks, components, App and Service Connectors, taskflow's /processes to extract the data from various source systems. - Extensively used various types of transformations - Expression, Joiner, Lookup, Filter, Aggregator, Hierarchy Parser/Builder, Web Service, and Intelligent Structure Model etc. to integrate the data from various source systems. - Developed Unix shell scripts to automate the ETL process. - Developed Python scripts to call APIs to download the data from Vendor sites. calling APIs to download the data from vendor sites. - Developed Snowflake External Stages, Storage Integration, Pipes, Streams, Tasks, Stored Procedures and Dynamic tables to extract the data from Cloud systems to Snowflake database. - Implemented optimal ETL performance strategies to improve the performance of jobs, reducing the credits consumed by IICS/Snowflake servers to process the data. - Implemented error handling methodologies to capture the invalid/bad records coming source systems. - Involved in Development, Unit Testing, SIT, UAT, Go-Live and Production phases of project.
  • Conocophillips
    Etl Developer/Data Architect
    Conocophillips Apr 2017 - Mar 2024
    Houston, Texas, United States
  • Accenture In India
    Application Development Associate Manager
    Accenture In India Sep 2014 - Apr 2023
    India
    - Worked as an Informatica Application Integration Lead for ConocoPhillips and was responsible for designing the ETL data integration solutions.- Interaction with business users and requirement gathering and develop technical design documents.- Developeed IICS ETL Mappings, Mappings tasks, Task flows, Process, Componenets, App and Service Connectors etc.- Developed Cloud Application Integration Process, Service Connectors to call APIs to download the data from Vendor Sites.- Extensively worked on developing Informatica PowerCenter Mapplets, Mappings, Sessions, Worklets and Workflows for data loading.- Worked on transformations such as Lookup, Aggregator, Expression, Joiner, Filter, Rank, Sorter, Router, Sequence Generator, Web Service transformation etc.- Created mappings of initial load for all source systems, cleansed data and load it into staging area.- Developed SCD Type1, SCD Type2 ETL patterns for various load strategies.- Extensively worked on using the PDO (Push down optimization), CDC (Change data capture) mechanism.- Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.- Identifies, researches, and resolves ETL root cause of production issues or system problems.- Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs using CONTROL-M schedulers and involved in migration deployment of ETL codes from development to production environment- Implemented error handling methodologies to capture the invalid/bad records coming source systems.- Responsible for creating the parameter files to connect to the right environment and data base Responsible for monitoring sessions. Debugged mapping of the failed session.- Was involved in conducting code review, Unit Test Cases, UAT and post go-live support.
  • Hp
    Senior Software Engineer
    Hp Jul 2009 - Sep 2014
    India
  • Satyam Computer Services Ltd
    Software Engineer
    Satyam Computer Services Ltd Apr 2008 - Jul 2009
    India

Vijay Reddy Education Details

Frequently Asked Questions about Vijay Reddy

What company does Vijay Reddy work for?

Vijay Reddy works for Capgemini

What is Vijay Reddy's role at the current company?

Vijay Reddy's current role is Informatica IDMC ETL Lead Developer.

What schools did Vijay Reddy attend?

Vijay Reddy attended University Of Madras, Chennai.

Who are Vijay Reddy's colleagues?

Vijay Reddy's colleagues are Payton Miller, Chetana Patil, Nikhil Gubba, Bhushan Wankhede, Yogesh Yadav, Sagili Vishnu Bharadwaja Reddy, Isha Paul.

Not the Vijay Reddy you were looking for?

  • Vijay Reddy

    Business Intelligence | Power Bi Developer | Data Analyst | Sql Sever Developer | Ssrs | Tableau
    Dallas, Tx
  • vijay reddy

    Golang Developer At Mgm Resorts International
    Fuquay-Varina, Nc
  • vijay reddy

    Azure Cloud | Architecture | Infrastructure Specialist | Lead Storage Engineer | Tech Innovator | Problem Solver | Cloud Computing.
    Greater Chicago Area
    2
    gmail.com, medline.com
  • Vijay Reddy

    Actively Looking For New Roles| Sr. Data Architect
    Atlanta, Ga
  • Vijay Reddy

    Saratoga, Ca
    5
    clear.ventures, gmail.com, intel.com, gmail.com, gmail.com

    1 (408) 7XXXXXXX

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.