US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 13th Dec 2024
● Analyze and interpret complex data sets. Ability to identify data anomalies and resolve data issues
● Understand specific business processes and domain concepts and relate them to data subject domains
● Collaborate with Data Leads, Data Analysts and QA analysts to validate requirements, participate in user requirement sessions
● Perform tests and validate data flows and prepare ETL processes according to business requirements
● Perform ETL tuning and SQL tuning
● Ability to document data flows representing business logic in ETL routines
● Design and implement data conversion strategy from legacy to new platforms
● Perform design validation, reconciliation, and error handling in data load processes
● Design and prepare technical specifications and guidelines including ER diagrams and related documents Qualifications
● Must be well versed with Data warehousing concepts including design patterns (Star schemas, Snowflake design schemas). Must be aware of data modeling concepts including the data modeling Normal forms
● Knowledge of AWS Infrastructure including S3, SNS, Ec2, CloudWatch and RDS
● 8-9 years working in ETL/Data transformation projects with one or more related products such as Informatica or Talend or Microsoft SSIS
● 8+ years working in business intelligence, data warehousing initiatives
● Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases like Oracle or Ms Sql Server or Vertica.
● Good to have at least 1+ years working with Matillion ELT tool and Snowflake Database
● Good to have experience in building AWS Data Pipelines using Python or Spark, SparkSQL in any of Cloud Environments (AWS / Azure / Google).
● Good to have - Experience with any of the NoSQL datastores such as ElasticSearch, MongoDB, DynamoDB, Cassandra