Sr. Data Engineer [100IT]

Experience- 2-5 yrs

Location- Bangalore

Job Description

We are actively seeking a Senior Data Engineer experienced building data pipelines and integrations from 3rd party data sources by writing custom automated ETL jobs using Python. The role will work in partnership with other members of the Business Analytics team to support the development and implementation of new and existing data warehouse solutions for our clients. This includes designing database import/export processes used to generate client data warehouse deliverables.

Please note that in a startup environment, you must be willing to pull up your sleeves and do some heavy lifting to get a product or service off the ground. This means you will be juggling different roles and being a master of all things when it comes to tech, including coding. The role needs a person who can solve anything quicker than anyone else. If the deadline is on fire, you need to work side by side with the team and code or run tests if they require your help.

Requirements

  • 2+ Years experience as an ETL developer with strong data architecture knowledge around data warehousing concepts, SQL development and optimization, and operational support models.
  • Experience using Python to automate ETL/Data Processes jobs.
  • Design and develop ETL and data processing solutions using data integration tools, python scripts, and AWS / Azure / On-Premise Environment.
  • Experience / Willingness to learn AWS Glue / AWS Data Pipeline / Azure Data Factory for Data Integration.
  • Develop and create transformation queries, views, and stored procedures for ETL processes, and process automation.
  • Document data mappings, data dictionaries, processes, programs, and solutions as per established standards for data governance.
  • Work with the data analytics team to assess and troubleshoot potential data quality issues at key intake points such as validating control totals at intake and then upon transformation, and transparently build lessons learned into future data quality assessments
  • Solid experience with data modeling, business logic, and RESTful APIs.
  • Solid experience in the Linux environment.
  • Experience with NoSQL / PostgreSQL preferred
  • Experience working with databases such as MySQL, NoSQL, and Postgres, and enterprise-level connectivity experience (such as connecting over TLS and through proxies).
  • Experience with NGINX and SSL.
  • Performance tune data processes and SQL queries, and recommend and implement data process optimization and query tuning techniques.

Benefits

It is a global management consulting firm with a unique and specialized focus on Data Science. We provide services across the whole value chain of an organization – Digital Strategy, Sales & Marketing, Supply Chain & Logistics as well as Finance.

You’ll have a blast doing it in our fun, passionate environment.

Job Category: IT
Job Type: Full Time
Job Location: Bangalore

Apply for this position

Allowed Type(s): .pdf, .doc, .docx