Job title: etl developer/ informatica developer + python + sql senior developer
contractor
remote
skill to evaluate
data engineer, data engineering, python development, sql, informatica development
experience
above 5-9 years
job description:
tavant technologies is seeking a senior developer to join our santander data pod team. This role involves collaborating with cross-functional teams to design, develop, and implement data solutions that enhance business operations. The ideal candidate will have strong experience in etl processes, proficiency in informatica, python, and sql, and a solid understanding of data warehousing concepts. You will be responsible for creating data pipelines, optimizing data flows, and ensuring data quality and integrity for analytics and reporting purposes. Additionally, your role will involve troubleshooting and resolving complex data issues, documenting processes, and working closely with business users to deliver effective data solutions.
responsibilities:
- design and implement etl processes using informatica to facilitate data integration from various sources.
- develop python scripts for data transformation and automation tasks.
- write complex sql queries to extract, manipulate, and analyze data from relational databases.
- collaborate with business stakeholders to gather requirements and understand data needs.
- monitor and optimize data workflows to ensure efficient performance.
- conduct data quality assessments and implement necessary improvements.
- document technical specifications and maintain code repositories.
- provide support for data-related inquiries and troubleshooting.
skills and tools required:
- proficiency in informatica powercenter or informatica cloud.
- strong experience in python programming for data manipulation and etl processes.
- advanced sql skills, with the ability to write and optimize complex queries.
- knowledge of data warehousing concepts and best practices.
- familiarity with relational databases, such as oracle, sql server, or postgresql.
- understanding of data governance, data quality, and data security principles.
- strong analytical and problem-solving skills.
- excellent communication and collaboration abilities to work effectively in a team environment.
preferred qualifications:
- experience with cloud data platforms (e.g., aws, azure) is a plus.
- familiarity with agile methodologies and devops practices.
- previous experience working in a financial services or banking environment.