Transforming Careers, One Opportunity at a Time At 3i People, we’re more than recruiters; we're career accelerators. Partnered with cutting-edge tech firms and innovative companies, we connect top-tier talent with their dream jobs. Our mission is to open doors for professionals like you to thriving workplaces where you can leave your mark. Title: Application Data Developer Expert Location: Remote Work Duration: 2 years contract Description We are seeking a skilled Data Engineer with AWS experience to design and develop ETL jobs for a DB2 data warehouse to support Cognos reporting needs. The ideal candidate will work closely with business intelligence teams to ensure efficient data extraction, transformation, and loading processes while optimizing database performance. This role requires strong expertise in DB2, AWS, and ETL development. • Design, develop, and maintain ETL jobs to ingest, transform, and load data into the DB2 data warehouse for Cognos reporting. • Utilize AWS services (S3, EC2, RDS, Step Functions, etc.) to optimize data processing workflows. • Implement best practices for data modeling to ensure efficient reporting in IBM Cognos Analytics. • Work with business and reporting teams to gather data transformation requirements and build pipelines accordingly. • Develop and optimize SQL queries, stored procedures, and indexing strategies for DB2. • Ensure data integrity, quality, and performance tuning of ETL processes. • Manage large-scale data migration and integration projects between cloud and on-prem DB2 systems. • Automate data workflows using AWS services. • Monitor, troubleshoot, and optimize ETL processes for performance and reliability. • Support Cognos report developers in structuring data efficiently to meet reporting needs. • Implement security, compliance, and data governance best practices for handling sensitive data. Qualifications: • 5+ years of experience in ETL development, data engineering, and data warehousing. • Strong hands-on experience with AWS services (S3, RDS, Redshift, etc.). • Expertise in DB2 database development, including SQL, stored procedures, and performance tuning. • Proficiency in Python or Shell scripting for automation. • Experience with IBM Cognos Analytics and understanding of reporting structures. • Strong problem-solving, analytical, and communication skills. • Experience working in Agile and DevOps environments. Preferred Qualifications: • Bachelors degree in computer science, Information Systems, or a related field. • Experience in Medicaid and/or Healthcare Plan environment is strongly preferred. • Knowledge of DB2 on AWS Cloud. • AWS Certified Data Analytics Specialty or AWS Certified Solutions Architect is a plus. Required Skills DB2, SQL, DevOps, Agile, ETL, AWS, Python Company Overview 3i People has been providing staffing solutions in IT and professional services for over 20+ years and has established a reputation for delivering top-quality talent to meet the unique requirements of their clients. We have developed a deep understanding of the industry and the evolving trends, which enables us to provide our clients with the most relevant talent. Additionally, our vast experience allows us to offer a personalized approach to staffing, catering to each client's specific needs. Overall, 3i People's extensive experience and expertise in the staffing industry make us a reliable and trusted partner for companies looking for top talent. Our commitment to delivering high-quality services and using innovative technologies, such as Leap Tiger, further set us apart from our competitors. With our personalized approach and dedication to excellence, 3i People is well-equipped to help clients succeed in the ever-changing business environment.