Integration Developer II

CBTS serves enterprise and midmarket clients in all industries across the United States and Canada. CBTS combines deep technical expertise with a full suite of flexible technology solutions including Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, CBTS delivers comprehensive technology solutions for its clients' transformative business initiatives. For more information, please visit www.cbts.com .

Job Purpose :

As an Integration Developer II, you will be a pivotal member of our IT team, responsible for designing, developing, and implementing sophisticated data integration solutions. This role demands strong technical proficiency, problem-solving abilities, and a proven track record in delivering complex integration projects. The successful candidate will collaborate effectively, drive innovation, and ensure the seamless flow of data across diverse systems.

Essential Functions :

Integration Solution Development :

Design, development, and maintenance of advanced data integration solutions using application integration software, ensuring seamless communication between diverse systems.

Implement data transformation, migration, and validation tasks, optimizing performance and ensuring data accuracy.

Reporting :

Utilize reporting software skills to create visually appealing, interactive reports, providing valuable business insights to stakeholders.

Collaborate closely with business analysts and stakeholders to understand reporting requirements and translate them into effective solutions.

Collaboration :

Collaborate on integration efforts, working closely with business analysts, stakeholders, and technical teams.

Collaborate with database administrators and other IT teams to ensure data security, integrity, and optimal database performance.

Performance Optimization and Troubleshooting :

Monitor integration processes, troubleshoot issues, and optimize performance to exceed predefined service level agreements (SLAs).

Create and maintain detailed documentation for integration processes, data mappings, and report specifications.

Continuous Improvement and Innovation :

Stay abreast of emerging trends, technologies, and best practices in data integration, reporting, and transformation, and drive their adoption within the team.

Education :

Four years of college resulting in a bachelor's degree or equivalent.N / A

Experience : 3-6 Years

3-6 years of proven experience as an Integration Developer.

Special Knowledge, Skills, and Abilities :

Strong understanding of integration concepts, data transformation strategies, and report development.

Proficiency in designing and implementing complex data integration workflows using application integration software.

Advanced knowledge of data cleansing, validation, and transformation using SSIS or similar integration tools.

Strong T-SQL skills including querying, optimization, and data modeling preferred.

Excellent problem-solving abilities and attention to detail.

Excellent communication and collaboration abilities, with the ability to drive results in a team-oriented environment.

Experience with other advanced integration tools and technologies preferred.

Knowledge of cloud-based integration solutions and data platforms (e.g., Azure Data Factory, AWS Glue) preferred.

Familiarity with working in a Scrum environment, collaborating effectively with cross-functional teams, and delivering high-quality results within agile frameworks preferred.

Familiarity with cloud platforms (e.g., Azure, AWS) and microservices architecture is preferred.

Supervisory Responsibility :

This position does not have any supervisory responsibilities.

Work Environment :

This position is in Chennai / Bangalore / Gurgaon.

Due to U.S. Government requirements applicable to foreign-owned telecommunications providers, non-US citizens may be required to submit to an extensive government agency background check which will necessitate disclosure of sensitive Personally Identifiable Information.

Skills Required

Ssis, T-sql, Azure Data Factory, Data Integration