MatchPoint Solutions
ETL/ Data Architect - Abinitio
MatchPoint Solutions, Phoenix, Arizona, United States, 85003
MatchPoint Solutions is a fast-growing, young, energetic global IT-Engineering services company with clients across the US. We provide technology solutions to various clients like Uber, Robinhood, Netflix, Airbnb, Google, Sephora, and more! More recently, we have expanded to working internationally in Canada, China, Ireland, UK, Brazil, and India. Through our culture of innovation, we inspire, build, and deliver business results, from idea to outcome. We keep our clients on the cutting edge of the latest technologies and provide solutions by using industry-specific best practices and expertise.
We are excited to be continuously expanding our team. If you are interested in this position, please send over your updated resume. We look forward to hearing from you!
This is a large impact role that demands someone who can excel in a fast paced and ever changing environment.
Role : ETL/ Data Architect - Abinitio
Pay rate- 85-90/hr (DOE)
Remote
Responsibilities:
Design, develop and maintain ETL processes using Ab Initio to integrate data as Iceberg on ADLS/SnowflakeOptimize ETL workflows to ensure efficient data processing and loading.Develop scripts to automate data processing and loading tasks.Implement data quality checks and validation processes within ETL workflows.Understanding business requirements/scope of projects, create ETL code as per business logic/process; be able to provide estimation for the tasks as required with supporting data points.Ensure data governance policies are adhered to, including data lineage and metadata management.Provide support for data-related issues and troubleshoot ETL-related problems.Create and maintain technical documentation and reports for stakeholders.Requirements - Must Have skills:
10+ years of total technical experience on designing, developing, and implementing ETL solutions using Ab Initio/Linux.Experience in complete Software Development Life Cycle which includes Systems Analysis of various applications in Client/Server Environment.Working with various software applications with advanced knowledge (such as Ab Initio, Azure ADLS, Spark, Snowflake, Data warehousing, SQL, CI/CD, Control M, Knowledge on Data Modelling, Python, Hive Thrift Server, lift, Apache Ranger)Experience in creating graphs, PSets, shell scripting, deployment activities, performance tuning and error handling skills.Excellent hands-on experience in various Transform, Partition/De-partition, Database, Dataset and XML components, .Analytical problem solving and business interaction skills.Must have strong exposure to Parallelism techniques, Generic graph design, EME and Data Warehousing concepts.Experience in writing complex Database queries (preferably Oracle and DB2).Effective communication with entire offshore team, customer and all concerned teams on day-to-day basis; provide daily status reporting to all stakeholders.
MatchPoint Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
We are excited to be continuously expanding our team. If you are interested in this position, please send over your updated resume. We look forward to hearing from you!
This is a large impact role that demands someone who can excel in a fast paced and ever changing environment.
Role : ETL/ Data Architect - Abinitio
Pay rate- 85-90/hr (DOE)
Remote
Responsibilities:
Design, develop and maintain ETL processes using Ab Initio to integrate data as Iceberg on ADLS/SnowflakeOptimize ETL workflows to ensure efficient data processing and loading.Develop scripts to automate data processing and loading tasks.Implement data quality checks and validation processes within ETL workflows.Understanding business requirements/scope of projects, create ETL code as per business logic/process; be able to provide estimation for the tasks as required with supporting data points.Ensure data governance policies are adhered to, including data lineage and metadata management.Provide support for data-related issues and troubleshoot ETL-related problems.Create and maintain technical documentation and reports for stakeholders.Requirements - Must Have skills:
10+ years of total technical experience on designing, developing, and implementing ETL solutions using Ab Initio/Linux.Experience in complete Software Development Life Cycle which includes Systems Analysis of various applications in Client/Server Environment.Working with various software applications with advanced knowledge (such as Ab Initio, Azure ADLS, Spark, Snowflake, Data warehousing, SQL, CI/CD, Control M, Knowledge on Data Modelling, Python, Hive Thrift Server, lift, Apache Ranger)Experience in creating graphs, PSets, shell scripting, deployment activities, performance tuning and error handling skills.Excellent hands-on experience in various Transform, Partition/De-partition, Database, Dataset and XML components, .Analytical problem solving and business interaction skills.Must have strong exposure to Parallelism techniques, Generic graph design, EME and Data Warehousing concepts.Experience in writing complex Database queries (preferably Oracle and DB2).Effective communication with entire offshore team, customer and all concerned teams on day-to-day basis; provide daily status reporting to all stakeholders.
MatchPoint Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.