ETL Architect

As a Senior Architect at our company, your primary responsibility will be integrating and mapping customer data from client source system(s) to our industry-leading platform. Your role includes, but is not limited to: - Using strong technical data migration, scripting, and organizational skills to ensure efficient and accurate conversion of client data to our platform. - Performing extract, transform, load (ETL) activities to guarantee accurate and timely data conversions. - Conducting in-depth research and analysis of complex scenarios to develop innovative solutions that meet customer needs while adhering to project governance. - Mapping and maintaining business requirements to the solution design using tools like requirements traceability matrices (RTM). - Presenting findings, requirements, and problem statements for validation by stakeholders and working groups. - Identifying and documenting data gaps to facilitate change impact and downstream impact analysis. Qualifications: - 10+ years of experience assessing data and analytic requirements to establish mapping rules from source to target systems to meet business objectives. - 5+ years of experience as a Tech Lead. - Experience with real-time, batch, and ETL for complex data conversions. - Working knowledge of extract, transform, load (ETL) methodologies and tools such as Informatica, DataStage, Dell Boomi, etc. - Utilization of data mapping tools to prepare data for data loads based on target system specifications. - Working experience using various data applications/systems such as Oracle SQL, Excel, .csv files, etc. - Strong SQL scripting experience. - Ability to communicate effectively with clients and/or Project Manager to scope, develop, test, and implement conversion/integration. - Demonstrated collaboration and problem-solving skills. - Working knowledge of software development lifecycle (SDLC) methodologies including Agile, Waterfall, and others. - Clear understanding of cloud and application integrations. - Ability to work independently, prioritize tasks, and manage multiple tasks simultaneously. - Experience in customer SIT, UAT, migration, and go-live support. The shift timings for this role are from 5 PM to 2 AM IST.,