Vijay Reddy Email and Phone Number
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.
Capgemini
View- Website:
- capgemini.com
- Employees:
- 321265
-
Informatica Idmc Etl Lead DeveloperCapgeminiBartlesville, Ok, Us -
Senior Iics Etl DeveloperConocophillipsBartlesville, Ok, Us -
Informatica/Iics LeadConocophillips Jun 2023 - PresentHouston, 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. -
Etl Developer/Data ArchitectConocophillips Apr 2017 - Mar 2024Houston, Texas, United States -
Application Development Associate ManagerAccenture In India Sep 2014 - Apr 2023India- 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. -
Senior Software EngineerHp Jul 2009 - Sep 2014India -
Software EngineerSatyam Computer Services Ltd Apr 2008 - Jul 2009India
Vijay Reddy Education Details
-
Bachelor Of Engineering In Computer Science
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 | TableauDallas, Tx -
-
vijay reddy
Azure Cloud | Architecture | Infrastructure Specialist | Lead Storage Engineer | Tech Innovator | Problem Solver | Cloud Computing.Greater Chicago Area2gmail.com, medline.com -
-
Vijay Reddy
Saratoga, Ca5clear.ventures, gmail.com, intel.com, gmail.com, gmail.com1 (408) 7XXXXXXX
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial