ETL Architect

• Location: Cincinnati, OH (Hybrid)
• # of Positions: 1
• Eligibility: Open
• Client Name / Domain: BFSI
• Bill Rate: $?? per hour
• Employment Mode: Contract / Corp-to-Corp
• Contract Duration: 12+ mos. Contract
• Experience: 12+ years
• Skills: AWS Datalake, BI/DW, Big Data, Talend, NoSQL, Data Warehouse, Data Analytics, AI

Job Requirement_

Client is looking for a ETL Architect.

• 10 - 12 years of experience in BI/DW development experience on-premises and on Cloud.
• Should have strong knowledge on DW concepts and BI on Cloud;
• Experience in at least one Large Scale Big Data and Cloud Implementation
• Work with customer in gathering business requirements for data migration needs and structure for AWS Data Lake
• Should have implementation experience in business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics)
• Should have proven experience in defining and governing data modeling and design standards, tools, best practices, and related development for enterprise data models.
• Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
• Should have knowledge and solutioning experience of AWS Cloud its related services.
• Should have experience in Analytics Cloud design and implementation involving data ingestion (real time or batch), implementation of AWS Data Lake/Data Warehouse/NoSQL database on Cloud, metadata management & data catalog and Reporting.
• Have experience in Onsite-Offshore model with various teams responsible Data & Analytics & AI
• Should have Data Quality Implementation experience for large scale BI/Big data Projects (at least 2/3 implementation)
• Awareness and exposure to Data Migration, Data Governance, Metadata Management, Master Data Management will be a big plus.

Responsibilities_

• Create the design and technical specifications for the ETL process of the project.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
• Work with various stake holders and implement complex mapping, designed slowly changing dimension Type1 and Type2.
• Guiding team members and stakeholders through new data concepts such as Data Stewards, Data Governance, and Data Owners, enhancing data management and governance practices of data load methods/ETL tools.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Create Workflows containing command, email, session, decision and a wide variety of tasks.
• Responsible for identifying bugs in existing mappings by analyzing data flow, evaluating transformations and fixing bugs.
• Tuning the mappings based on criteria, creating partitions in case of performance issues.
• Perform data validation after the successful End to End tests and appropriate error handling in ETL processes.

Please visit the Jobs Page on our website to get the full job description.

RESPONDENTS [ please read carefully ]

U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time. Any equivocation or misrepresentation will be reported to USCIS and BBB.

ABOUT US (Equal Opportunity Employer)

At TP USA we are proud to celebrate diversity of people for the benefit of our employees, our products, and the global community we all belong to. It is the policy of TP USA Inc., and its subsidiaries, to provide equal employment opportunities to all employees and applicants for employment. All employment practices such as recruitment, selection, promotions, and other terms and conditions of employment are administered in a manner designed to ensure that employees and applicants for employment or services are not subjected to discrimination on the basis of age, race, color, sex, sexual orientation, gender identity, national origin, ancestry, medical condition, disability, marital status, religious or political preferences or union affiliation.