Data Mart Developer

This position is for a Data Mart developer role (ACH Data Mart TM), who will be working on Money Movement Data Mart for ACH Project and other Data Mart specific initiatives to be delivered as a part of overall Data Mart & Modernization initiative. The candidate is required to have strong financial/payments domain knowledge and technical capabilities required to implement the project. The role will provide the technical mentorship required for the enhancements planned for ACH Data Mart Project. Job Description Data Mart Developer Roles & Responsibilities This position is for a Data Mart developer role (ACH Data Mart TM), who will be working on Money Movement Data Mart for ACH Project and other Data Mart specific initiatives to be delivered as a part of overall Data Mart & Modernization initiative. The candidate is required to have strong financial/payments domain knowledge and technical capabilities required to implement the project. The role will provide the technical mentorship required for the enhancements planned for ACH Data Mart Project. Must Have 10+ years of strong experience in designing and implementing ETL/ELT processes, scalable data pipelines, and robust data integration frameworks. 10+ Extensive knowledge of database systems and analytics concepts, including query optimization and data processing techniques. 10+ Strong proficiency in scripting and programming languages, with a preference for Python, for data processing and automation. 5+ Hands-on experience with cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP), including data services and storage solutions. 5+ Support analytical data models with pre-aggregations and drill-down capabilities 5+ Deep understanding of data modeling (dimensional and relational), data warehousing, and big data architecture principles. 5+ Very good understanding and hands on experience in Microsoft Power BI (Data modeling, DAX, Optimization, visualization best practices) 5+ Develop data mart structures supporting reporting, analytics, and regulatory needs 5+ Experience in AI/ML application in the data lake/warehouse areas, knowledge of medallion architecture. 5+ Strong understanding of data warehousing concepts and best practices. Knowledge of data security and compliance in cloud environments. 5+ Design, Develop and support real-time and near real-time data processing pipelines 5+ Implement data quality controls (accuracy, completeness, timeliness) 5+ Good understanding of implementation of authentication and authorization on application level. 5+ Very good understanding of performance optimization. Nice To Have 5+ Experience working in the financial industry domain. Preferred in Payments Domain. 5+ Align models with ISO20022 standards, BIAN domains, and enterprise data taxonomy 5+ Integrate data across multiple payment rails e.g. ACH, Wires, RTP, FedNow, Zelle 5+ Build unified data models for cross-rail analytics and reporting. Salary Range- $100,000-$120,000 a year #J-18808-Ljbffr Tata Consultancy Services