> Markdown version of [/jobs/ext/730434-technical-architect](https://www.wearedevelopers.com/jobs/ext/730434-technical-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Technical Architect - **Company:** Tata Consultancy Services Limited - **Location:** Charlotte, NC, United States - **Experience:** Expert - **Salary:** $90,000.0 - $141,000.0 - **Contract:** Permanent contract - **Skills:** Agile Methodology, CA Workload Automation Ae, Data Cleansing, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Database Queries, Hadoop Distributed File System, MapReduce, Apache HBase, Apache Hive, JSON, Job Scheduling, NoSQL, Apache Oozie, Oracle (Applications), Parsing, Performance Tuning, PL-SQL, SQL Databases, Sqoop, System Testing, Extensible Markup Language (XML), Apache Zookeeper, Apache Yarn, Informatica Powercenter, Apache Spark, Apache Flume, Information Technology, Apache Kafka, Bitbucket, Software Version Control - **Published:** June 29, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=885549a51287d1b9 ## About the Role Do you have a Bachelor's degree?, Secondary: Oracle, SQL Experience: Minimum 10 years Roles & Responsibilities ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools. * Deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie. * Experience with Spark, Kafka, NoSQL databases. * Experience in Agile Methodology * Experience with code versioning tools like Bit-Bucket * SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data. * Exposure to advanced transformations like data transformations, Parsing JSON/XML messages * Experience in Job scheduling tools Like Autosys, Qualifications : BACHELOR OF COMPUTER SCIENCE ## Description * Data Integration: Integrate data from various sources, ensuring data consistency and quality. * Data Warehouse Design: Design and maintain data warehouses to support business intelligence activities. * Performance Optimization: Optimize SQL script/queries for speed and efficiency. * Troubleshooting: Identify and resolve issues in ETL processes. * Documentation: Create and maintain technical documentation for ETL processes. * Testing: Perform unit, integration, and system testing on ETL processes. * Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes. * Data Quality: Ensure data quality by implementing data cleansing and transformation processes. * Data Modeling: Develop and maintain relational and dimensional data models. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Leveraging Real time data in FSIs](https://www.wearedevelopers.com/videos/806-leveraging-real-time-data-in-fsis) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) - [Tomorrow's cloud data platforms - fully managed database-as-a-service (DBaaS)](https://www.wearedevelopers.com/videos/254-tomorrow-s-cloud-data-platforms-fully-managed-database-as-a-service-dbaas) ## Related Articles - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)