Springfield, IL, 62762, USA
7 days ago
SR ETL Technical Lead
About us: Cognizant is one of the world's leading professional services companies, transforming clients' business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant (a member of the NASDAQ-100 and one of Forbes World’s Best Employers 2024) is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com Roles and Responsibilities **Designing and Developing ETL Processes:** This involves designing and coding ETL workflows using Informatica PowerCenter or other ETL tools, ensuring efficient data flow from source to target. **Data Extraction, Transformation, and Loading:** Extracting data from various sources, transforming it according to business requirements, and loading it into a data warehouse or other target system. **Data Quality and Integrity:** Implementing data validation and cleansing techniques to ensure data accuracy and reliability. **Hadoop Integration:** Designing and developing data pipelines that utilize Hadoop technologies like HDFS, MapReduce, and Hive to handle large volumes of data. **Python Scripting:** Using Python to automate tasks, write custom transformations, and enhance ETL processes. **Performance Optimization:** Optimizing ETL processes for speed and efficiency, identifying and resolving performance bottlenecks. **Documentation and Maintenance:** Maintaining clear and comprehensive documentation of ETL processes and actively participating in the ongoing maintenance and enhancement of existing systems. **Collaboration:** Working with business stakeholders, other data engineers, and developers to ensure data quality and meet business requirements. Required Skills and Qualifications: · **Informatica PowerCenter (or similar ETL tool) Expertise:** Proficiency in designing, developing, and debugging ETL mappings and workflows. + **Hadoop Ecosystem Knowledge:** Experience with Hadoop technologies like HDFS, MapReduce, Hive, and Spark. + **Python Programming Skills:** Proficiency in Python for scripting, data manipulation, and automation. + **Data Modeling and Data Warehouse Design:** Understanding of data modeling concepts and experience with designing data warehouses. + **SQL Proficiency:** Experience with SQL for data querying, manipulation, and database interaction. + **Data Quality and ETL Best Practices:** Understanding of data quality principles and best practices for ETL development. + **Strong Problem-Solving and Analytical Skills:** Ability to identify and resolve complex issues within ETL processes. + **Communication and Collaboration Skills:** Ability to effectively communicate technical information to both technical and non-technical audiences. Application Expired date : 4/15/2025 The annual salary for this position is between $[125,000 – 148,000] depending on experience and other qualifications of the successful candidate. This position is also eligible for Cognizant’s discretionary annual incentive program and stock awards, based on performance and subject to the terms of Cognizant’s applicable plans. Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements: + Medical/Dental/Vision/Life Insurance + Paid holidays plus Paid Time Off + Long-term/Short-term Disability + Paid Parental Leave + Employee Stock Purchase Plan Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law. \#LI-AV1#CB#Ind123 Cognizant is an equal opportunity employer that embraces diversity, champions equity and values inclusion. We are dedicated to nurturing a community where everyone feels heard, accepted and welcome. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other protected characteristic as outlined by federal, state or local laws.
Confirm your E-mail: Send Email