SQL ETL

Job Description

SQL & ETL Developer

Software Requirements:

• Strong expertise in SQL for querying and manipulating databases.
• Proficiency in ETL tools, specifically SQL Server Integration Services (SSIS) or Informatica.
• Knowledge of database management systems (e.g., SQL Server, Oracle).
• Familiarity with data warehousing concepts and methodologies.

Overall Responsibilities:

• Data Extraction & Transformation: Design and implement ETL processes to extract data from various sources, transform it into the desired format, and load it into target systems.
• Database Management: Manage and optimize SQL databases, ensuring high performance and data integrity.
• Data Quality Assurance: Monitor and ensure the accuracy, consistency, and quality of data throughout the ETL process.
• Collaboration: Work closely with business analysts, data architects, and other stakeholders to understand data requirements and deliver effective data solutions.
• Documentation: Prepare and maintain clear documentation of ETL processes, data mappings, and operational procedures.
• Troubleshooting: Identify, diagnose, and resolve data-related issues, making adjustments to ETL processes as necessary.

Category-wise Technical Skills:

• SQL Skills: Advanced SQL skills, including data modeling and database design.
• ETL Tools: Proficiency in ETL development using SSIS or Informatica.
• Database Management: Experience with SQL Server or Oracle database management systems.
• Data Warehousing: Understanding of dimensional modeling and ETL best practices.
• Scripting: Familiarity with scripting languages like Python or PowerShell is a plus.

Experience:

5 years of relevant experience in SQL development and ETL processes, with demonstrated proficiency in using SSIS or Informatica.

Day-to-Day Activities:

• Developing ETL workflows and processes for data extraction, transformation, and loading.
• Conducting performance tuning and optimization of SQL queries and ETL jobs.
• Collaborating with stakeholders to gather requirements and provide data solutions.
• Monitoring and maintaining ETL jobs, ensuring they run smoothly and on schedule.
• Documenting procedures and best practices for data management and ETL processes.

Qualifications:

• Bachelors degree in Computer Science, Information Technology, or a related field.
• 5 years of experience in SQL development and ETL solutions.

Soft Skills:

• Exceptional analytical and problem-solving skills.
• Detail-oriented with a strong commitment to data quality.
• Effective communication and interpersonal skills to collaborate with cross-functional teams.
• Ability to adapt to changing requirements and prioritize tasks effectively.

SYNECHRONS DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative Same Difference is committed to fostering an inclusive culture promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicants gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice

Locations: Bengaluru - GTP

---