Highlights
About Us: CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Optimize ETL workflows for performance, reliability, scalability, and maintainability using established tuning techniques and best practices.
Numbers & Facts
| Location | Atlanta, Georgia |
| Industry | Computer/IT Services |
| Company Size | 2,500 to 4,999 employees |
| Year Founded | 1966 |
| Website | http://www.ctg.com/ |
Description
Description:
CTG is seeking to fill an ETL Data Engineer – Informatica PowerCenter position for our client.
Location: Atlanta, GA
Duration: 4 months
Duties:
Design, develop, test, and maintain ETL solutions using Informatica PowerCenter to support enterprise data warehouse and regulatory reporting requirements.
Analyze business and technical requirements and translate them into scalable, reliable data integration solutions.
Perform data profiling, source system analysis, and business rule validation to support data integration initiatives.
Design and implement Extract, Transform, and Load (ETL) processes to transfer data from operational and external environments into business intelligence and data warehouse environments.
Optimize ETL workflows for performance, reliability, scalability, and maintainability using established tuning techniques and best practices.
Investigate and resolve production issues, ETL failures, data discrepancies, and performance bottlenecks through detailed root cause analysis.
Conduct data validation, reconciliation, and quality checks to ensure data accuracy, completeness, consistency, and integrity.
Perform impact analysis for source system changes and assess downstream effects on ETL processes, data warehouses, and reporting solutions.
Collaborate with business analysts, data architects, developers, and other technical teams throughout the data integration lifecycle.
Develop and maintain technical documentation, data mappings, ETL specifications, and operational procedures.
Skills:
Strong proficiency with Informatica PowerCenter and enterprise ETL development.
Solid understanding of ETL architecture, data integration patterns, and data warehouse concepts.
Experience with data profiling, source-to-target mapping, data validation, reconciliation, and data quality processes.
Strong SQL skills for data analysis, validation, troubleshooting, and performance tuning.
Ability to analyze complex data flows and identify data integration issues and performance bottlenecks.
Strong troubleshooting and root cause analysis skills.
Knowledge of enterprise data warehouse and business intelligence environments.
Excellent analytical, problem-solving, communication, and collaboration skills.
Familiarity with other enterprise data integration tools such as Ab Initio or IBM DataStage/WebSphere Data Integration Suite is a plus.
Experience:
Experience designing, developing, and supporting enterprise ETL solutions using Informatica PowerCenter.
Experience working with data integration projects involving operational, external, data warehouse, and business intelligence environments.
Experience analyzing business and technical requirements and converting them into effective ETL solutions.
Experience with production support, ETL troubleshooting, data discrepancies, and performance optimization.
Experience performing source system analysis, impact analysis, data profiling, and business rule validation.
Experience supporting regulatory reporting or other data-intensive enterprise applications is preferred.
Education:
Bachelor’s degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field, or equivalent professional experience.
Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.
CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.
To Apply:
To be considered, please apply directly to this requisition using the link provided. Kindly forward this to any other interested parties. Thank you!
CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years’ experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries.
Together, we shape what’s next—working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you’ll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit www.ctg.com.
CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.
CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.
About Company
CTG (NASDAQ: CTG) provides industry-specific IT services and solutions that address the business needs and challenges of clients in high-growth industries in North America and Western Europe. CTG also provides strategic staffing services for major technology companies and large corporations. Backed by more than 50 years of experience and proprietary methodologies, CTG has a proven track record of reliably delivering high-value, industry-specific staffing services and solutions to its clients. CTG has operations in North America, Western Europe, and India.
CTG's greatest asset is its people, and as such, we are committed to providing employees programs and processes to support their performance, hone their skills, and advance in their careers. This commitment is reflected by CTG being named a Best Places to Work in Healthcare company by Modern Healthcare (2013-2016) in North America, and a Best Workplace in the United Kingdom (2013), Belgium (since 2007), and Luxembourg (since 2011).
CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.
CTG is an Equal Opportunity/Affirmative Action Employer and strong advocate of workforce diversity. Minority/Female/Sexual Orientation/Gender Identity/Disability/Veteran.
CTG's greatest asset is its people, and as such, we are committed to providing employees programs and processes to support their performance, hone their skills, and advance in their careers. This commitment is reflected by CTG being named a Best Places to Work in Healthcare company by Modern Healthcare (2013-2016) in North America, and a Best Workplace in the United Kingdom (2013), Belgium (since 2007), and Luxembourg (since 2011).
CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.
CTG is an Equal Opportunity/Affirmative Action Employer and strong advocate of workforce diversity. Minority/Female/Sexual Orientation/Gender Identity/Disability/Veteran.
Similar Job Searches
Software Engineer Jobs in Atlanta, GASoftware Design Engineer Jobs in Atlanta, GASoftware Development Manager Jobs in Atlanta, GABuild Engineer Jobs in Atlanta, GASoftware Developer Jobs in Atlanta, GASystems Software Developer Jobs in Atlanta, GAScrum Master Jobs in Atlanta, GASoftware Architect Jobs in Atlanta, GASolutions Architect Jobs in Atlanta, GADirector Of Software Development Jobs in Atlanta, GA