Blumetra Solutions is a US based Software Product Engineering firm headquartered in US San Francisco and has a development center in Hyderabad Indore India.
We are specialized in providing Digital services like Data Management (MDM Data Quality Data Governance) & Data Analytics Cloud Business Applications and Quality Assurance were partnered with our customers across different industries like Retail financial services high tech pharmaceuticals and other industries to help them achieve their digital transformation objectives.
Were platinum partners for Informatica AWS Snowflake etc. and an ISO certified organization.
Position: ETL Lead Developer
Work Location: Hyderabad
Experience 8 to 15 years
Employment Type: Full time
No. of positions 1
Prerequisites:
- Relevant Experience: 8 15 years of handson experience
- A selfmotivated gogetter and outofthebox thinker
- Must possess a high degree of ownership integrity and learnability
- Must be able to work as an individual contributor as well as a great team player
- Must have strong fundamentals in data orchestration & data transformations
- Must have flair to design and develop data intensive and data driven solutions
Required HandsOn Skills:
- Leverage tools & technologies like IBM Datastage Informatica Powercenter/IICS or Matillion or FiveTran or any other ETL tools. (Informatica PC will be preferred or candidate should be open to learning it)
- Designing & developing data loads & transformations master workflows exception handling
- Integrate Data Quality (IDQ) rules & data reconciliation as part of orchestration
- Craft SQL queries using joins aggregates merge/upsert etc
- Perform change data capture (CDC)
- If a candidate is lacking in knowledge of ETL tool but has excellent knowledge of SQL stored procedures and can perform complex ETL tasks using SQL Queries willing to learn ETL technologies will be considered
Candidates preferred with experience in one or more from below:
- Have orchestrated data from Salesforce (SFDC) Oracle Netsuite Marketo Workato etc
- Have worked with JSON Parquet ORC or XML file formats
- Have worked on cloud EDW like Snowflake Redshift Synapse DeltaLake etc
- Have leveraged Role Based Access Control (RBAC) Data Catalog Data Governance
- Understand cloud (AWS/Azure) storage & compute leveraging them effectively
Would be awesome if the candidate has:
- Knowledge of developing & deploying multitenant SAAS applications.
- Ability to develop JAVA & Python scripts and integrate as part of orchestration
- Ability to reverse engineer existing implementation & created a better dimensional model.
- Excellent troubleshooting and problem solving capabilities.
- Good written and verbal communication skills.
java,ibm datastage,cloud (aws/azure),python,data,sql,cloud,data governance,salesforce,json,etl,informatica powercenter