Vijay Reddy
Senior ETL Developer- Informatica/IICS/IDMC | Snowflake | Azure/AWS Data Engineering | Unix/Python scripting & SQL | Certified in Informatica Intelligent Cloud Data & Application Services | Agile Delivery
- Role
- Senior Iics Etl Developer at ConocoPhillips
- Location
- Bartlesville, OK, US
- LinkedIn followers
- 500 followers
About Vijay Reddy
Twelve plus years of IT experience with a strong background in SDLC, Data Integration…
Experience
Senior Iics Etl Developer
Jun 2023 — Present
Working as a Senior ETL Informatica IICS/IDMC developer 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
Education
University of Madras, Chennai
Bachelor of Engineering in Computer Science
Skills
- Oracle, Unix, Teradata
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.