As a SQL + Python Developer, you will serve as a key player in developing, maintaining, and optimizing robust SQL-based data structures while leveraging Python to create scalable applications and automate workflows. This position is pivotal in ensuring efficient data management, seamless integration of systems, and actionable insights derived from data. Collaborating closely with cross-functional teams, including developers, data engineers, and analysts, you will drive the success of data-driven projects and contribute to the overall data infrastructure.
Key Responsibilities
Database Design and Management
- Design, implement, and maintain efficient SQL databases, including creating tables, views, indexes, and schemas tailored for optimal performance and scalability.
- Develop, test, and optimize complex SQL queries, stored procedures, and triggers to support application features and business requirements.
Python Application Development
- Develop Python scripts and applications to automate data extraction, transformation, and loading (ETL) processes.
- Leverage Python libraries (e.g., Pandas, NumPy, SQLAlchemy) to manipulate, analyze, and visualize data effectively.
Data Integration and Reporting
- Build integrations between Python applications and SQL-based systems to streamline data manipulation, reporting, and visualization workflows.
- Work with APIs and ETL tools (e.g., AWS Glue) to enable seamless data integration across platforms.
Performance Optimization and Troubleshooting
- Monitor and enhance database performance by identifying and resolving bottlenecks, inconsistencies, and inefficiencies.
- Debug and troubleshoot Python scripts and database-related issues to ensure reliability and accuracy.
Collaboration and Documentation
- Collaborate with business analysts and stakeholders to understand data requirements and deliver tailored solutions.
- Prepare and maintain comprehensive documentation for SQL queries, Python scripts, workflows, and processes.
Data Governance and Security
- Ensure data integrity, security, and consistency across all SQL databases and applications.
- Implement best practices for managing sensitive data and complying with data protection regulations.
Continuous Improvement
- Stay updated with industry trends, tools, and technologies to incorporate best practices in data engineering and automation.
- Proactively evaluate existing systems and suggest improvements to optimize performance and scalability.
Required Skills and Qualifications
- Proven experience in SQL development, including database design, query optimization, and performance tuning.
- Proficiency in Python programming, with expertise in libraries such as Pandas, NumPy, and SQLAlchemy.
- Hands-on experience with relational databases (e.g., MySQL, PostgreSQL, MS SQL Server) and database management tools.
- Familiarity with ETL tools, data pipelines, and integration techniques, including APIs and cloud-based platforms like AWS Glue.
- Strong analytical skills with the ability to work on large datasets and extract meaningful insights.
- Knowledge of version control systems like Git to manage code changes and collaboration.
- Attention to detail, excellent problem-solving skills, and the ability to work both independently and within a team.
- Strong written and verbal communication skills to effectively convey technical information to non-technical stakeholders.
Preferred Experience
- Working knowledge of cloud ecosystems, including Azure or AWS, for database and application hosting.
- Exposure to machine learning concepts or tools to integrate data-driven models into workflows.
- Experience with dashboarding tools like Tableau or Power BI for advanced visualization.
Experience Level
- 4.5 to 6 years of professional experience in SQL development, Python programming, and data engineering.
About Infogain
Infogain is a human-centered digital platform and software engineering company headquartered in Silicon Valley. As a trusted partner to Fortune 500 companies and digital natives, we specialize in engineering business outcomes across industries such as technology, healthcare, insurance, travel, telecom, retail, and consumer goods.
Leveraging cutting-edge technologies, including cloud computing, microservices, IoT, artificial intelligence, and automation, Infogain accelerates experience-led transformations through innovative digital platforms. Our capabilities are recognized globally, including being a Microsoft Gold Partner and an Azure Expert Managed Services Provider (MSP).